How to display values in listbox from db using ASP.NET MVC

Question

passing all values in list but it is displaying as NaN in listbox.

[AllowAnonymous]
public ActionResult GetColumnnames(ReportsModel Model)
{
string Tablename = Request.Form["Tables"].ToString();
List<string> ColumnNamesList = DBFunctionOBj.GetColumnNames(Tablename);
SelectList Values = new SelectList(ColumnNamesList, "", "",0);
Model.Fieldnames = Values;
var result = new { Values };
return Json(result, JsonRequestBehavior.AllowGet);
// return View(Model);
}

<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>     <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>   <script type="text/javascript">     $(document).ready(function () {         $('#Tables').change(function () {             var id = $('#Tables').val();             alert(id);             $.ajax({                 type: "POST",                 url: '@Url.Action("GetColumnnames", "MCPAdmin")',                 data: { Tables: $('#Tables').val() },                 datatype: "json",                 traditional: true,                   success: function (data) {                                        $('#AvailableFields').empty();                     //iterate over the data and append a select option                     $.each(data, function (item) {                         $('#AvailableFields').append('<option value="' + item.Values + '">'                             + + '></option>');                                              })                 }             });         });     }); </script>

@Html.ListBox("AvailableFields", new SelectList(""), new { @class = "form-control editable" })

Satyaprakash Samantaray · Answer

https://www.codeproject.com/Questions/1190015/How-to-display-values-in-listbox-from-db-using-ASP

Rupesh Kahane · Answer

Hi Venkata Please refer below article 1) https://www.codeproject.com/Articles/771999/ASP-Net-MVC-How-to-create-a-ListBox Note: You have to select values from your database into a key value pair ( Text & Value ) like your Primary Key and Name field. Suppose you want to show a data into a dropdownlist then write code into a controller as IEnumerable listClients = UnitoffWork.ClientDetailsRepository.GetAll(); var listToClient = listClients.Select(p => new { p.Name p.Id }).ToList(); var items = listToClient.Select(i => new SelectListItem { Text = i.Name Value = i.Id.ToString() }); ViewBag.ClientListNames = items; Now your code of .cshtml page is as @Html.DropDownList(CurrentClientName ViewBag.ClientListNames as IEnumerable SelectListItem >  -Select- new { @ id = ClientId  @ class = form- control }) In above code their is ClientDetail is my model. In database their is Name & Id. I have used repository pattern & unit of work.