CheckBoxList和RadioButtonList控件的绑定

来源:互联网 发布:mac双系统windows黑屏 编辑:程序博客网 时间:2024/04/29 23:21

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();
        }