GridView和CheckBox结合

2008-11-08 11:26

后台: public partial class Default4 : System.Web.UI.Page {     SqlConnection sqlcon;     string strCon = "Data Source=(local);Database=db_Examination;Uid=sa;Pwd=sqlgly";     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {             bind();         }     }     protected void CheckBox2_CheckedChanged(object sender, EventArgs e)     {         for (int i = 0; i <= GridView1.Rows.Count - 1; i++)         {             CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");             if (CheckBox2.Checked == true)             {                 cbox.Checked = true;             }             else             {                 cbox.Checked = false;             }         }     }     protected void Button2_Click(object sender, EventArgs e)     {         sqlcon = new SqlConnection(strCon);         SqlCommand sqlcom;         for (int i = 0; i <= GridView1.Rows.Count - 1; i++)         {             CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");             if (cbox.Checked == true)             {                 string sqlstr = "delete from tb_student where id='" + GridView1.DataKeys[i].Value + "'";                 sqlcom = new SqlCommand(sqlstr, sqlcon);                 sqlcon.Open();                 sqlcom.ExecuteNonQuery();                 sqlcon.Close();             }         }         bind();     }     protected void Button1_Click(object sender, EventArgs e)     {         CheckBox2.Checked = false;         for (int i = 0; i <= GridView1.Rows.Count - 1; i++)         {             CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");             cbox.Checked = false;         }     }     public void bind()     {         string sqlstr = "select * from tb_student";         sqlcon = new SqlConnection(strCon);         SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);         DataSet myds = new DataSet();         sqlcon.Open();         myda.Fill(myds, "tb_Member");         GridView1.DataSource = myds;         GridView1.DataKeyNames = new string[] { "id" };         GridView1.DataBind();         sqlcon.Close();     } } 前台: <div>     <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"                         CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px">                         <FooterStyle BackColor="White" ForeColor="#000066" />                         <Columns>                         <asp:TemplateField>                                 <ItemTemplate>                                      <asp:CheckBox ID="CheckBox1" runat="server" />                                 </ItemTemplate>                         </asp:TemplateField>                         <asp:BoundField DataField="id" HeaderText="用户ID" />                         <asp:BoundField DataField="name" HeaderText="用户姓名" />                         <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex"/>                                                    </Columns>                                                  <RowStyle ForeColor="#000066" />                         <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />                         <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />                         <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />                             </asp:GridView>                     <asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" Font-Size="9pt" OnCheckedChanged="CheckBox2_CheckedChanged"                         Text="全选" />                     <asp:Button ID="Button1" runat="server" Font-Size="9pt" Text="取消" OnClick="Button1_Click" />                     <asp:Button ID="Button2" runat="server" Font-Size="9pt" Text="删除" OnClick="Button2_Click" />     </div>