GridView控件的批量删除操作

        1.批量删除

          在进行批量删除时，需要一列选择框，让用户进行选择删除的条目。因此，在GridView 控件的   <Columns></Columns>标签对中加入需要进行选择的选择框控件。

     <asp:TemplateField HeaderText="删除">

                            <ItemTemplate>

                                <asp:CheckBox ID="del" runat="server" />

                            </ItemTemplate>

                        </asp:TemplateField>

        2.删除前确认

         在这里使用Button1按钮进行删除任务，那在进行删除前需要用户进行最后确认，只需要在page_load事件中添加如下一行程序：

        Button1.Attributes.Add("onclick", "return confirm(确认要删除选中项吗?')");

       3.全选记录按钮的事件代码

          当用户单击Button2时，如果Text是全选，执行选中所有的行，并设定该按钮为取消，此时再次单击Button2，就取消所有选择。代码如下

      protected void Button2_Click(object sender, EventArgs e)

      {

          CheckBox cb;

          if (Button2.Text == "全选")

          {

              for (int i = 0; i < GridView1.Rows.Count; i++)

              {

                cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("del");

                  cb.Checked = true;

              }

              Button2.Text = "取消";

          }

          else

          {

              for (int i = 0; i < GridView1.Rows.Count; i++)

              {

                cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("del");

                  cb.Checked = false;

              }

              Button2.Text = "全选";

          }

      }

      其中del是CheckBox的ID值。

    4.删除记录的按钮代码

      protected void Button1_Click(object sender, EventArgs e)

      {

          string sql = "delete from Categories where";

          string cal = "";

          for (int i = 0; i < GridView1.Rows.Count; i++)

          {

              CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("del");

              if (cb.Checked==true)

              {

                  cal += " CategoryID=" + GridView1.DataKeys[i].Value.ToString() + " or";

              }

          }

        if (cal != "")

          {

              sql += cal.Substring(0, cal.Length - 3);

          }

          else

          {

            sql = "";

          }

           objConnection = new OleDbConnection(strConnect);

            cmd = new OleDbCommand(sql, objConnection);

            objConnection.Open();

            int ii= cmd.ExecuteNonQuery();

            objConnection.Close();

            if (ii > 0)

            {

                Response.Write("<script>alert('删除成功！');</script>");

                // 更新GridView控件

                gridViewBind(this.TreeView1.SelectedNode.Value);

            }

       }