GridView和CheckBox结合

5.GridView和CheckBox结合：

效果图：

1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12public partial class Default5 : System.Web.UI.Page
13{
14 //清清月儿http://blog.csdn.net/21aspnet 
15    SqlConnection sqlcon;
16    string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
17    protected void Page_Load(object sender, EventArgs e)
18    {
19        if (!IsPostBack)
20        {
21            bind();
22        }
23    }
24    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
25    {
26        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
27        {
28            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
29            if (CheckBox2.Checked == true)
30            {
31                cbox.Checked = true;
32            }
33            else
34            {
35                cbox.Checked = false;
36            }
37        }
38    }
39    protected void Button2_Click(object sender, EventArgs e)
40    {
41        sqlcon = new SqlConnection(strCon);
42        SqlCommand sqlcom;
43        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
44        {
45            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
46            if (cbox.Checked == true)
47            {
48
49                string sqlstr = "delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[i].Value + "'";
50                sqlcom = new SqlCommand(sqlstr, sqlcon);
51                sqlcon.Open();
52                sqlcom.ExecuteNonQuery();
53                sqlcon.Close();
54            }
55        }
56        bind();
57    }
58    protected void Button1_Click(object sender, EventArgs e)
59    {
60        CheckBox2.Checked = false;
61        for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
62        {
63            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
64            cbox.Checked = false;
65        }
66    }
67    public void bind()
68    {
69        string sqlstr = "select top 5 * from 飞狐工作室";
70        sqlcon = new SqlConnection(strCon);
71        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
72        DataSet myds = new DataSet();
73        sqlcon.Open();
74        myda.Fill(myds, "tb_Member");
75        GridView1.DataSource = myds;
76        GridView1.DataKeyNames = new string[] { "身份证号码" };
77        GridView1.DataBind();
78        sqlcon.Close();
79    }
80}

1<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
 2    CellPadding="3" Font-Size="9pt"  BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px">
 3    <FooterStyle BackColor="White" ForeColor="#000066" />
 4    <Columns>
 5   <asp:TemplateField>
 6   <ItemTemplate>
 7   <asp:CheckBox ID="CheckBox1" runat="server" />
 8  </ItemTemplate>
 9  </asp:TemplateField>
10  <asp:BoundField DataField="身份证号码" HeaderText="用户ID" SortExpression="身份证号码" />
11        <asp:BoundField DataField="姓名" HeaderText="用户姓名" SortExpression="姓名"/>
12        
13        <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>
14            
15    </Columns>
16    <RowStyle ForeColor="#000066" />
17    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
18    <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
19    <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
20</asp:GridView>
21 <asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" Font-Size="9pt" OnCheckedChanged="CheckBox2_CheckedChanged"
22    Text="全选" />
23<asp:Button ID="Button1" runat="server" Font-Size="9pt" Text="取消" OnClick="Button1_Click" />
24<asp:Button ID="Button2" runat="server" Font-Size="9pt" Text="删除" OnClick="Button2_Click" />
25
26