public List<UserInfo> list = new List<UserInfo>();
//查询采购员
SqlConnection conn = new SqlConnection("Server=.;Database=JiYunMaterials;user id=sa;password=root;");
SqlDataAdapter sda = new SqlDataAdapter("select * from tbl_Group", conn);
// string sq = "select UserName from UserInfo";
DataTable ds = new DataTable();
// Com c = new Com();
// ds = c.GetTable(sq);
DataTable ds = new DataTable();
sda.Fill(ds);
list = Com.ConvertDataTableToList<UserInfo>(ds);
//qiantai代码
采购人: <select id="select1" name="select1">
<option value="请选择" selected="selected">请选择</option>
<%
for(int i=0;i<list.Count;i++){ %>
<option value="<%=list[i].ID %>">
<%=list[i].UserName %>
</option>
<% } %>
</select>
<br />
C# 动态显示下拉列表的数据(3)
最新推荐文章于 2024-05-10 15:31:30 发布