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 ;
                }
            }
        }
    }
}