天天看点

@Html.DropDownList 从数据库加载选择项

后台代码:

1 构造selectlist,通过viewbag传到前端

var assetNameList = middleResult.Select(p=>p.AssetName).Distinct();

SelectList selList1 = new SelectList(assetNameList);

ViewBag.assetNameList = selList1;

var departmentNameList = middleResult.Select(p=>p.DepartmentName).Distinct();

 SelectList selList2 = new SelectList(departmentNameList);

 ViewBag.departmentNameList = selList2;

前端代码:

2 前端获取selectlist,"assetName"和"departmentName"为form表单提交数据时的参数名

@Html.DropDownList("assetName", ViewBag.assetNameList as SelectList)

@Html.DropDownList("departmentName", ViewBag.departmentNameList as SelectList)