Values not displaying in listbox from database using mvc5

Hi all

i want to display values in listbox from database and values getting in controller json method but displaying as [Object Object] like this..

Controller:-

--------------

public ActionResult GetColumnsByFavouriteReport(ReportsModel Model,string Columns) 
{    
 List ReportColumnsList = MCPAdminControllerPageObject.GetColumnsByReportName(Columns);    
 return Json(ReportColumnsList, JsonRequestBehavior.AllowGet);
 }

View :-

-------

$(document).ready(function () { $('#FavouriteReports').change(function () { $.ajax({               type: "POST",               url: '@Url.Action("GetColumnsByFavouriteReport", "MCPAdmin")',               data: { Columns: $('#FavouriteReports').val() },               datatype: "json",               traditional: true,               success: function (data) { $('#SelectedFields').empty(); $.each(data, function (key, val) { $('#SelectedFields').append(' key + '">' + val + ''); }) } }); }); 

 @Html.ListBoxFor(m => m.SelectedFields, new SelectList(new[] { "" }), new { @class = "form-control editable" })

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyaprakash Samantaray9y ago
check key value pair
0
Rupesh Kahane9y ago
Try this
You have to select values from your database into a key value pair ( Text & Value ) like your Primary Key and Name field.
var listToR = ReportColumnsList.Select(p => new { p.Name, p.Id  }).ToList();
var items = listToR .Select(i => new SelectListItem { Text = i.Name, Value = i.Id.ToString() });
return Json(items, JsonRequestBehavior.AllowGet);
All the best
0