C#代码:一下是CS下的代码,那在页面中我只放置了3个按钮和1个CheckBoxList控件
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
//这里是在数据库中取出数据
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["bjfanau"].ConnectionString);
con.Open(); //打开连接
SqlCommand cmd = new SqlCommand("select * from mc_sys", con);
SqlDataReader sdr = cmd.ExecuteReader();
this.CheckBoxList1.DataTextField = "s_title"; //这里是显示的文本的数据库字段
this.CheckBoxList1.DataValueField = "s_id"; //这里是隐藏的值的数据库字段
this.CheckBoxList1.DataSource = sdr;
this.CheckBoxList1.DataBind(); //数据绑定
sdr.Close();
con.Close();
}
}
//这块是做选着完后点提交在页面上答应出复选框的值(注意是值不是文本)
protected void Button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (this.CheckBoxList1.Items[i].Selected)
{
Response.Write(this.CheckBoxList1.Items[i].Value.ToString() + " | ");
}
}
}
//这块是全选按钮的事件,点次按钮就全部CheckBoxList都会被选中
protected void Button2_Click(object sender, EventArgs e)
{
for (int b = 0; b < CheckBoxList1.Items.Count; b++)
{
this.CheckBoxList1.Items[b].Selected = true;
}
}
//这块是全选按钮的事件,点次按钮就全部CheckBoxList全部不选
protected void Button3_Click(object sender, EventArgs e)
{
for (int b = 0; b < CheckBoxList1.Items.Count; b++)
{
this.CheckBoxList1.Items[b].Selected = false;
}
}
}