CheckBox与DataGrid混用&DataSet批量删除数据

.aspx代码

<form id="Form1" method="post" runat="server">
   <p>
    <asp:DataGrid id="dgrdName" runat="server" BorderStyle="None" BorderWidth="1px" BorderColor="#CC9966"
     BackColor="White" CellPadding="4" Font-Size="9pt" Font-Names="verdana" AutoGenerateColumns="False">
     <SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
     <ItemStyle ForeColor="#330099"></ItemStyle>
     <HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
     <FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
     <Columns>
      <asp:TemplateColumn>
       <HeaderTemplate>
        <asp:CheckBox ID="chkAll" OnCheckedChanged="chkAll_changed" Runat="server" AutoPostBack="True"></asp:CheckBox>
       </HeaderTemplate>
       <ItemTemplate>
        <asp:CheckBox ID="chkDel" Runat="server"></asp:CheckBox>
       </ItemTemplate>
      </asp:TemplateColumn>
      <asp:BoundColumn DataField="classid" HeaderText="编号"></asp:BoundColumn>
      <asp:BoundColumn DataField="classname" HeaderText="姓名"></asp:BoundColumn>
     </Columns>
     <PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
    </asp:DataGrid>
   </p>
   <p>
    <asp:Button id="Button1" runat="server" Text="删除所选条目"></asp:Button>
   </p>
  </form>

.aspx.cs后台代码

  protected System.Web.UI.WebControls.DataGrid dgrdName;
  protected System.Web.UI.WebControls.Button Button1;
  SqlConnection myConn; 
  string strSql; 
  SqlDataAdapter myComm; 
  DataSet ds; 
  SqlCommandBuilder nameCmdBd;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!IsPostBack) 
   { 
    BindGrid(); 
   } 
  }

private void BindGrid() 
  {//数据绑定
   myConn=new SqlConnection(ConfigurationSettings.AppSettings["SqlConnString"].ToString()); 
   strSql="select * from newsclass"; 
   myComm=new SqlDataAdapter(strSql,myConn); 
   ds=new DataSet(); 
   myComm.Fill(ds,"user"); 
   dgrdName.DataSource=ds.Tables["user"].DefaultView; 
   dgrdName.DataBind(); 
  }

  public void chkAll_changed(object sender,EventArgs e) 
  {//全选
   CheckBox cb=(CheckBox)sender; 
   foreach(DataGridItem i in dgrdName.Items) 
   { 
    CheckBox cb1=(CheckBox)i.FindControl("chkDel"); 
    if(cb.Checked) 
     cb1.Checked=true; 
    else 
     cb1.Checked=false; 
   } 
  }    

  private void Button1_Click(object sender, System.EventArgs e)
  {//删除选择项
   myConn=new SqlConnection(ConfigurationSettings.AppSettings["SqlConnString"].ToString()); 
   strSql="select * from newsclass"; 
   myComm=new SqlDataAdapter(strSql,myConn); 
   ds=new DataSet(); 
   myComm.Fill(ds,"name"); 
   for(int i=0;i<dgrdName.Items.Count;i++) 
   { 
    CheckBox cb=(CheckBox)dgrdName.Items[i].FindControl("chkDel"); 
    if(cb.Checked) 
    { 
     ds.Tables["name"].Rows[i].Delete(); 
    } 
   } 
   nameCmdBd=new SqlCommandBuilder(myComm); 
   myComm.Update(ds,"name"); 
   dgrdName.DataSource=ds.Tables["name"].DefaultView; 
   dgrdName.DataBind(); 
  }

  private void dgrdName_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {//分页
   dgrdName.CurrentPageIndex=e.NewPageIndex;
   BindGrid(); 
  }