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

Seshu B

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 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);
}

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

2 Replies

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

Satyaprakash Samantaray9y ago
https://www.codeproject.com/Questions/1190015/How-to-display-values-in-listbox-from-db-using-ASP
Rupesh Kahane9y ago
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.