Question

select标签下拉框内容怎么从数据库中取出

select下拉框的内容是user表中所有的username数据该怎么实现呢

Answer 1

在前台,
<select name="userId" id="userId">
<%=Getuser(Request["user"]) %>
</select>

在後台,
public string Getuser(object selected)
{
List<user> list = MyRegionManage.GetMyRegions();//
StringBuilder buffer = new StringBuilder(string.Format(Option, 0, "", "请选择"));
if (list != null)
{
foreach (user m in list)
{
string _checked = "";
if (selected != null && Convert.ToInt32(selected) == m.Id) _checked = "selected='selected'";
buffer.AppendFormat(Option, m.Id, _checked, m.Name);
}
}
return buffer.ToString();
}