how to retrieve data id and name from table to html select using json or ajax
[HttpGet]
public JsonResult GetDepartement(string text)
{
IQueryable<Departement> departement;
List<object> listObj = new List<object>();
object obj = new object();
departement = db.Departements;
if (!string.IsNullOrEmpty(text))
departement = departement.Where(m => m.departement.Contains(text));
List<Departement> data = departement.OrderBy(m => m.departement).ToList();
foreach (Departement item in data)
{
obj = new
{
id = item.id,
departement = item.departement,
create_date = item.create_date ?.ToString("yyyy-MM-dd HH:mm:ss"),
last_update = item.last_update ?.ToString("yyyy-MM-dd HH:mm:ss")
};
listObj.Add(obj);
}
return Json(listObj, JsonRequestBehavior.AllowGet);
}
<div class="col-sm-6">
<div class="input-group">
<span class="input-group-addon"><i class="fa fa-id-card"></i></span>
<select class="form-control" id="select-departement">
</select>
</div>
</div>
$(window).on('load', function () {
//load dropdown departement name on partial view input form occuption
loaddepartement();
})
function loaddepartement() {
var url = 'MasterData/GetDepartement';
var selectdepartment = $('#select-departement');
$.getJSON(url, function (data) {
});
};