Datagrid怎么根据选择的checkbox编辑和更新多行记录？

有网友问这个问题，写了一个简单的例子：

前台：

<% @ Page language = " c# "  Codebehind = " WebForm4.aspx.cs "  AutoEventWireup = " false "  Inherits = " WebApplication25.WebForm4 "   %>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"  >
< HTML >
     < HEAD >
         < title >WebForm4 </ title >
         < meta  name ="GENERATOR"  Content ="Microsoft Visual Studio .NET 7.1" >
         < meta  name ="CODE_LANGUAGE"  Content ="C#" >
         < meta  name ="vs_defaultClientScript"  content ="JavaScript" >
         < meta  name ="vs_targetSchema"  content ="http://schemas.microsoft.com/intellisense/ie5" >
     </ HEAD >
     < body >
         < form  id ="Form1"  method ="post"  runat ="server" >
             < asp:DataGrid  id ="DataGrid1"  runat ="server"  AutoGenerateColumns ="False"  DataKeyField ="EmployeeID" >
                 < Columns >
                     < asp:TemplateColumn >
                         < ItemTemplate >
                             < input  type ="hidden"  id ="SelectedID"  runat ="server"  value ='<%#  Container.ItemIndex% >' name="SelectedID"/>
                             < asp:CheckBox  ID ="chkExport"  Runat ="server"   />
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:BoundColumn  DataField ="EmployeeID"  HeaderText ="EmployeeID" ></ asp:BoundColumn >
                     < asp:TemplateColumn  HeaderText ="FirstName" >
                         < ItemTemplate >
                             < asp:Label  ID ="lab_FirstName"  Runat ="server"  Text ='<%#DataBinder.Eval(Container.DataItem,"FirstName")% >'>
                             </ asp:Label >
                             < asp:TextBox  ID ="txt_FirstName"  Runat ="server"  Text ='<%#DataBinder.Eval(Container.DataItem,"FirstName")% >' Visible="False">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                     < asp:TemplateColumn  HeaderText ="LastName" >
                         < ItemTemplate >
                             < asp:Label  ID ="lab_LastName"  Runat ="server"  Text ='<%#DataBinder.Eval(Container.DataItem,"LastName")% >'>
                             </ asp:Label >
                             < asp:TextBox  ID ="txt_LastName"  Runat ="server"  Text ='<%#DataBinder.Eval(Container.DataItem,"LastName")% >' Visible="False">
                             </ asp:TextBox >
                         </ ItemTemplate >
                     </ asp:TemplateColumn >
                 </ Columns >
             </ asp:DataGrid >
             < asp:Button  id ="Button1"  runat ="server"  Text ="编辑" ></ asp:Button >
             < asp:Button  id ="Button2"  runat ="server"  Text ="更新" ></ asp:Button >
         </ form >
     </ body >
</ HTML >

后台：

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebApplication25
{
     ///   <summary>
     ///  WebForm4 的摘要说明。
     ///   </summary>
     public  class WebForm4 : System.Web.UI.Page
    {
         protected System.Web.UI.WebControls.Button Button1;
         protected System.Web.UI.WebControls.Button Button2;
         protected System.Web.UI.WebControls.DataGrid DataGrid1;
         protected System.Web.UI.HtmlControls.HtmlInputHidden SelectID;
    
         private  void Page_Load( object sender, System.EventArgs e)
        {
             //  在此处放置用户代码以初始化页面
             if(!IsPostBack)
            {
                SetBind();
            }
        }

         private  void SetBind()
        {
            SqlConnection conn= new SqlConnection("server=srvxglai-sha;uid=sa;pwd=321413;database=northwind");
            SqlDataAdapter da= new SqlDataAdapter("select * from Employees",conn);
            DataSet ds= new DataSet();
            da.Fill(ds,"table1");
             this.DataGrid1.DataSource=ds.Tables["table1"];
             this.DataGrid1.DataBind();            
        }


         #region Web 窗体设计器生成的代码
         override  protected  void OnInit(EventArgs e)
        {
             //
             //  CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
             //
            InitializeComponent();
             base.OnInit(e);
        }
        
         ///   <summary>
         ///  设计器支持所需的方法 - 不要使用代码编辑器修改
         ///  此方法的内容。
         ///   </summary>
         private  void InitializeComponent()
        {    
             this.Button1.Click +=  new System.EventHandler( this.Button1_Click);
             this.Button2.Click +=  new System.EventHandler( this.Button2_Click);
             this.Load +=  new System.EventHandler( this.Page_Load);

        }
         #endregion

         private  void Button1_Click( object sender, System.EventArgs e)
        {
             foreach(DataGridItem di  in  this.DataGrid1.Items) 
            { 
                 if(((CheckBox)di.FindControl("chkExport")).Checked== true) 
                { 
                    ((TextBox)di.FindControl("txt_FirstName")).Visible= true;
                    ((TextBox)di.FindControl("txt_LastName")).Visible= true;
                    ((Label)di.FindControl("lab_FirstName")).Visible= false;
                    ((Label)di.FindControl("lab_LastName")).Visible= false;
                } 
            } 

        }

         private  void Button2_Click( object sender, System.EventArgs e)
        {
             foreach(DataGridItem di  in  this.DataGrid1.Items) 
            { 
                 if(((CheckBox)di.FindControl("chkExport")).Checked== true) 
                { 
                     if(((TextBox)di.FindControl("txt_FirstName")).Text!=((Label)di.FindControl("lab_FirstName")).Text||((TextBox)di.FindControl("txt_LastName")).Text!=((Label)di.FindControl("lab_LastName")).Text)
                    {
                        Response.Write("记录号:"+ this.DataGrid1.DataKeys[ int.Parse(((HtmlInputHidden)di.FindControl("SelectedID")).Value)]+",FirstName:"+((TextBox)di.FindControl("txt_FirstName")).Text+",LastName:"+((TextBox)di.FindControl("txt_LastName")).Text+"<br>");
                    }
                    ((TextBox)di.FindControl("txt_FirstName")).Visible= false;
                    ((TextBox)di.FindControl("txt_LastName")).Visible= false;
                    ((Label)di.FindControl("lab_FirstName")).Visible= true;
                    ((Label)di.FindControl("lab_LastName")).Visible= true;
                    ((CheckBox)di.FindControl("chkExport")).Checked= false;
                }
            }
        }
    }
}