用Hashtable表绑定数据到下拉框、复选框列表、单选框列表、ListBox

  //前台
<asp:RadioButtonList ID="rb1" runat="server">
</asp:RadioButtonList>
<asp:DropDownList ID="ddlshe" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlshe_SelectedIndexChanged">
</asp:DropDownList>
<br />
<asp:ListBox ID="lba" runat="server"></asp:ListBox>
<br />
<asp:CheckBoxList ID="cbl" runat="server">
</asp:CheckBoxList>
//后台:
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = ".";
builder.InitialCatalog = "MyDatas";
builder.IntegratedSecurity = true;
using (SqlConnection con = new SqlConnection(builder.ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("select id,title from tb_forums", con);
using (SqlDataReader reader = cmd.ExecuteReader())
{
Hashtable ht = new Hashtable();
while (reader.Read())
{
ht.Add(reader["title"].ToString(), reader["title"].ToString());
}
ddlshe.Items.Clear();
lba.Items.Add("请选择");//ListBox
ddlshe.Items.Add("请选择"); //下拉框列表
rb1.Items.Add("请选择"); //单选框列表
cbl.Items.Add("请选择");//复选框列表
foreach (DictionaryEntry de in ht)
{
ListItem item = new ListItem(de.Value.ToString(), de.Key.ToString());
ddlshe.Items.Add(item);
lba.Items.Add(item);
cbl.Items.Add(item);
rb1.Items.Add(item);
}
}
}
}
posted on 2012-04-02 10:02  Stephen_潮  阅读(519)  评论(0编辑  收藏  举报