如何在html视图中将数据从数据库中获取到Dropdownlist [英] How to get data to Dropdownlist from database in html view

问题描述

我正在创建一个网页，其中包含 Dropdownlist 。我必须从数据库中检索drop_down_list的数据。有没有办法从数据库中获取数据到html视图我的html代码：

< select name =drop down> < option value =1> @ test.list [i]< / option>< / select>

I得到的数据库值的列表变量，但我不知道如何将数据传递给HTML视图。请帮助我解决这个问题。谢谢

解决方案

您需要创建选择项目列表：

您的动作与视图包中的项目列表：

  public ActionResult ActionName（）
 {
 List< SelectListItem> Items = new List< SelectListItem>（）; 
 CustReportName.Add（new SelectListItem（）{Text =List1，Value =1，Selected = false}）; 
 CustReportName.Add（new SelectListItem（）{Text =List2，Value =2，Selected = true}）; 
 ViewBag.ListItems = Items; 
 return View（ViewName）; 
 
  

来自数据库表的多个值

  public ActionResult ActionName（）
 {
 IEnumerable< SelectListItem> ItemsList =来自YourTableObject中的item 
选择新的SelectListItem 
 {
 Value = Convert.ToString（item.Id），
 Text = item.ItemName 
}; 
 ViewBag.ListItems = new SelectList（ItemsList，Value，Text）; 
返回视图（ViewName）; 
 
  

您的DropdownList查看：

  @ Html.DropDownListFor（model => model.ItemId，new SelectList（ViewBag.ItemList，Value，Text，0） ， - 选择项目 - ，新的{@class =form-control，@id =ItemId}）
  

干杯!!

I am creating an web page in which have a Dropdownlist. I have to retrieve data for the drop_down_list from the database. Is there any way to get data from the database to the html view my html code:

<select name="drop down"><option value="1">@test.list[i]</option></select>

I got the database value to the list variable but I don't know how to pass the data to the html view. Please help me in this issue.Thanks

解决方案

You need to create Select List of Items :

Your Action with List of Items in View Bag :

public ActionResult ActionName()
{
 List<SelectListItem> Items = new List<SelectListItem>();
        CustReportName.Add(new SelectListItem() { Text = "List1", Value = "1", Selected = false });
        CustReportName.Add(new SelectListItem() { Text = "List2", Value = "2", Selected = true });
        ViewBag.ListItems = Items;
return View("ViewName");
}

For Multiple values from database table:

public ActionResult ActionName()
{
IEnumerable<SelectListItem> ItemsList = from item in YourTableObject
select new SelectListItem
{
Value = Convert.ToString(item.Id),
Text = item.ItemName
};
ViewBag.ListItems = new SelectList(ItemsList, "Value", "Text");
return View("ViewName");
}

Your DropdownList On view :

@Html.DropDownListFor(model => model.ItemId, new SelectList(ViewBag.ItemList, "Value", "Text", 0), "-Select Item-", new { @class = "form-control", @id = "ItemId" })

Cheers !!

这篇关于如何在html视图中将数据从数据库中获取到Dropdownlist的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！