下拉框绑定数据

/// <summary>
/// 下拉框绑定
/// </summary>
/// <returns></returns>
public List<addlei> YEzhu()
{
string sql = "SELECT * FROM T_YEzhuBiao";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable de = new DataTable();
da.Fill(de);
var result = from s in de.AsEnumerable()
select new addlei
{
yezhuID = s.Field<int>("yezhuID"),
WYname = s.Field<string>("WYname")
};
return result.ToList();
}

///控制器

//获取下拉列表的值
var result = new BLL.denglubll().Userinfo();
SelectList list = new SelectList(result, "ID", "Name");
ViewBag.list = list;

///视图

@using (Html.BeginForm("add", "denglu", FormMethod.Post, new { @enctype = "multipart/form-data" }))
{
<table>
<tr>
<td>缴费人</td>
<td>@Html.DropDownListFor(T => T.yezhuID, ViewBag.list1 as SelectList, new { @class = "form-control" })</td>
</tr>
<tr>
<td>收费人</td>
<td>@Html.DropDownListFor(T => T.ID, ViewBag.list as SelectList, new { @class = "form-control" })</td>
</tr>
<tr>
<td>费物</td>
<td>@Html.DropDownListFor(T => T.SfID, ViewBag.list2 as SelectList, new { @class = "form-control" })</td>
</tr>
<tr>
<td><input id="Button1" type="submit" value="保存" /></td>
</tr>
</table>
}

转载于:https://www.cnblogs.com/htbmvc/p/7880807.html