CheckBoxList和RadioButtonList控件的绑定

最新推荐文章于 2021-03-05 09:42:27 发布

liu_111111

最新推荐文章于 2021-03-05 09:42:27 发布

阅读量1k

点赞数

分类专栏：程序文章标签： CheckBoxList控件的绑定 DataBind RadioButtonList控件的绑定 SQLHelper类

本文链接：https://blog.csdn.net/liu_111111/article/details/8243613

版权

程序专栏收录该内容

121 篇文章 0 订阅

订阅专栏

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:

前台：

<body>

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