ASP.NET读取数据绑定dropDownList控件实例
在工具箱把DropDownList控件拖到页面中，命名为RsDownlist .aspx源码 asp:DropDownList ID="RsDownlist" runat="server" /asp:DropDownList .aspx.cs源码 string _sql = string.Empty; _sql = "select [id],[funName] from [DyjRights] w
在工具箱把DropDownList控件拖到页面中，命名为RsDownlist
.aspx源码
<asp:DropDownList ID="RsDownlist" runat="server">
</asp:DropDownList>
.aspx.cs源码
string _sql = string.Empty;
_sql = "select [id],[funName] from [DyjRights] where [layer]=0";
RsDownlist.Items.Add(new ListItem("选择类别",""));
DataTable dt = SqlHelper.ExecuteProDataTable(SqlHelper.dbconn(), CommandType.Text, _sql, null);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
RsDownlist.Items.Add(new ListItem(dr["funName"].ToString(),dr["id"].ToString()));
}
}
dt.Dispose();
- 上一篇：编程战略：必须学习的十项.NET技术
- 下一篇：ASP.NET连接MySQL
精彩图集
精彩文章