SQLHelper类:
public static DataTable ExecuteDataTable(string sql, params SqlParameter[] pms)
{
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sql,connStr);
if (pms != null)
{
adapter.SelectCommand.Parameters.AddRange(pms);
}
adapter.Fill(dt);
return dt;
}
Web.config:
<connectionStrings>
<add name="Test1Constr" connectionString="data source=PC_THINK-THINK;initial Catalog=Test1;User id=sa;password=111111;"/>
</connectionStrings>
前台:
<body>
<form id="form1" runat="server"><div>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
</asp:RadioButtonList>
<br />
<br />
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
</asp:CheckBoxList>
</div>
</form>
</body>
后台:
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select * from province";
DataTable dt = SQLHelper.ExecuteDataTable(sql);
this.RadioButtonList1.DataSource = dt;
this.RadioButtonList1.DataTextField = "Provinces";
this.RadioButtonList1.DataValueField = "PId";
this.RadioButtonList1.DataBind();
this.CheckBoxList1.DataSource = dt;
this.CheckBoxList1.DataTextField = "Provinces";
this.CheckBoxList1.DataValueField = "PId";
this.CheckBoxList1.DataBind();
}