GridView操作一条记录的N种方式

结合GridView自身的特点，总结出操作（可以是删除、导入、更新等)单条记录的N种方式

首先，前台文件内容如下：

< asp:GridView  ID ="GVList"  runat ="server"  ShowFooter ="true"  AutoGenerateColumns ="False"
                BorderStyle ="Solid"  BorderColor ="#ffffff"  GridLines ="Horizontal"  CellSpacing ="1"
                Width ="100%"  HorizontalAlign ="NotSet"  BorderWidth ="0px"  EnableViewState ="true"
                DataKeyNames ="PKID" >
                 < Columns >
                     < asp:TemplateField >
                         < HeaderStyle  Width ="60px"  BackColor ="#1C5E55"  ForeColor ="White"   />
                         < HeaderTemplate >
                            </ HeaderTemplate >
                         < ItemTemplate >
                             < asp:Label  ID ="PKID"  Text ='<%#  DataBinder.Eval(Container.DataItem,"PKID")% > ' runat="server"
                                Visible="true"  Width="10"/>
                                  < asp:Label  ID ="FilePath"  Text ='<%#  DataBinder.Eval(Container.DataItem,"FilePath")% > ' runat="server"
                                Visible="true"  Width="700"/>
                         </ ItemTemplate >
                     </ asp:TemplateField >
                   
                     < asp:TemplateField >
                         < HeaderStyle  Width ="60px"   />
                         < HeaderTemplate >
                            操作 </ HeaderTemplate >
                         < ItemTemplate >
                             < asp:LinkButton  ID ="cmdImport"  ForeColor ="Red"  Text ="操作"  CssClass ="ElementNavigation"
                                CausesValidation ="false"  runat ="server"  CommandName ="Import"  OnClientClick ="javascript:return confirm('确定操作已选择的数据吗？')"   />
                         </ ItemTemplate >
                     </ asp:TemplateField >< asp:CommandField  DeleteText ="操作"  ShowDeleteButton ="true"  ButtonType ="Button"  HeaderStyle-Width ="40px"   />

                                    </ Columns >
             </ asp:GridView >

 其次：在后台Page_Load()事件是注册以下事件

Code
 if (GVList != null)
            {
                GVList.RowDataBound += new GridViewRowEventHandler(GVList_RowDataBound);
                GVList.RowCommand += new GridViewCommandEventHandler(GVList_RowCommand);
                GVList.RowDeleting += new GridViewDeleteEventHandler(GVList_RowDeleting);
            }

同时添加以下事件

  private   void  GVList_RowUpdating( object  sender, GridViewUpdateEventArgs e)
         { }

现分别说明各事件的作用如下：

 第一种操作方式，用GVList_RowDeleting事件

Code
  protected void GVList_RowDataBound(object sender, GridViewRowEventArgs e)
          {
              if (e.Row.RowType == DataControlRowType.DataRow)
              {
                  LinkButton lbUpdate = (LinkButton)e.Row.FindControl("cmdImport");
                  if (lbUpdate != null) { lbUpdate.CommandArgument = SQLParser.StringParse(DataBinder.Eval(e.Row.DataItem, "FilePath")); }
              }
          }
   private void GVList_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {GridView a = (GridView)sender;
              try
              {
                  string fullpath = SQLParser.StringParse(a.DataKeys[e.RowIndex]["FilePath"]);//.ToString();
                  if (fullpath.Length > 0)
                  {
                      Read Excel to Table#region Read Excel to Table
                      //处理该条记录
                      #endregion
                  }
  

              }
              catch (Exception ex)
              {
                  Loghandle by Tony 2008.11.21#region Loghandle by Tony 2008.11.21
                  //string loginid = EmptyString;
                  //myLogger.Error(GetErrorMessage(loginid, 1), ex);
                   #endregion
              }
              //BindList();
          }

第二种方式,用GVList_RowCommand事件

Code
protected void GVList_RowDataBound(object sender, GridViewRowEventArgs e)
          {
              if (e.Row.RowType == DataControlRowType.DataRow)
              {
                  LinkButton lbUpdate = (LinkButton)e.Row.FindControl("cmdImport");
                  if (lbUpdate != null) { lbUpdate.CommandArgument = SQLParser.StringParse(DataBinder.Eval(e.Row.DataItem, "FilePath")); }
              }
          } 
 
  private void GVList_RowCommand(object sender, GridViewCommandEventArgs e)
          {
              Execute Batch Operations#region  Execute Batch Operations
              if (e.CommandName == "Import")
              {
                  try
                  {
                      string fullpath = SQLParser.StringParse(e.CommandArgument);//.ToString();
                      if (fullpath.Length > 0)
                      {
                       Read Excel to Table#region Read Excel to Table
                      //处理该条记录
                      #endregion
 

                      }
                  }
                  catch (Exception ex)
                  {
                      Loghandle by Tony 2008.11.21Loghandle by Tony 2008.11.21#region Loghandle by Tony 2008.11.21
                      //string loginid = EmptyString;
                      //myLogger.Error(GetErrorMessage(loginid, 1), ex);
                      #endregion
                  }
                  //BindList();
              }
              #endregion
          }

 第三种方式，在数据不大的情况下，可以用ViewState来缓存DataTable,此时可以直接操作DataTable的Row,只需找到Row的索引即可。

 第四种方式，可以用GridViewRow来找到索引，道理同上， 可以参考
http://msdn.microsoft.com/zh-cn/library/system.web.ui.webcontrols.gridviewrow.aspx

转载于:https://www.cnblogs.com/downmoon/archive/2008/12/04/1347581.html