在GridView中的批量删除！

<% @ Page Language = " C# "  AutoEventWireup = " true "  CodeBehind = " Default.aspx.cs "  Inherits = " WebApplication1.Default "   %>

<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >
< html  xmlns ="http://www.w3.org/1999/xhtml" >
< head  runat ="server" >
     < title ></ title >
</ head >
< body >
     < form  id ="form1"  runat ="server" >
     < div >
         < br  />
         < asp:Button  ID ="btnDelete"  runat ="server"  Text ="删除选中项"  OnClick ="btnDelete_Click"
            Style ="height: 21px"   />
         < br  />
         < br  />
        <% --  通过给GridView1添加属性:DataKeyNames来获取主键; -- %>
         < asp:GridView  ID ="GridView1"  runat ="server"  AutoGenerateColumns ="false"  
            Width ="881px"  DataKeyNames ="id" >
             < Columns >
                 < asp:BoundField  DataField ="id"  HeaderText ="编号"   />
                 < asp:BoundField  DataField ="uname"  HeaderText ="名称"   />
                 < asp:TemplateField  HeaderText ="选择" >
                     < ItemTemplate >
                         < asp:CheckBox  ID ="cbxId"  runat ="Server"   />
                     </ ItemTemplate >
                 </ asp:TemplateField >
             </ Columns >
         </ asp:GridView >
     </ div >
     </ form >
</ body >
</ html >

using  System;
using  System.Web.UI.WebControls;
using  System.Data;

namespace  WebApplication1
{
     public   partial   class  Default : System.Web.UI.Page
    {
         protected   void  Page_Load( object  sender, EventArgs e)
        {
             if  ( ! this .IsPostBack)
            {
                GetData();
            }
        }

         // 绑定数据
         protected   void  GetData()
        {
             string  sql  =   " select * from userinfo " ;
            GridView1.DataSource  =  SQLHelper.GetDateSet(sql, CommandType.Text);
            GridView1.DataBind();
        }

         protected   void  btnDelete_Click( object  sender, EventArgs e)
        {
             // sqlText用于拼接SQL语句;
             string  sqlText  =   " ( " ;
             foreach  (GridViewRow objGVR  in   this .GridView1.Rows)
            {
                 // 判断当前行是否为数据行;
                 if  (objGVR.RowType  ==  DataControlRowType.DataRow)
                {
                    CheckBox objCB  =  objGVR.FindControl( " cbxId " )  as  CheckBox;

                     if  (objCB.Checked)
                    {
                         // 获取选中行的主键;
                        sqlText  +=   this .GridView1.DataKeys[objGVR.RowIndex][ " id " ].ToString()  +   " , " ;
                    }
                }
            }

             // 去掉最后的逗号，并且加上右括号 ,如果不去掉最后一个逗号变会成这样(1,2,3,4,5,6,)
            sqlText  =  sqlText.Substring( 0 , sqlText.Length  -   1 )  +   " ) " ;

            sqlText  =   " delete userinfo where id in "   +  sqlText;

            Response.Write( " 拼接后的SQL语句为： "   +  sqlText);
             // 执行删除语句 
             int  delCount  =  Convert.ToInt32(SQLHelper.ExecuteNonQuery(sqlText, CommandType.Text));

            Response.Write( " 共删除数据: "   +  delCount  +   " 条 " );

             this .GetData();


        }
    }
}