方便的使用单击和双击更新DataGrid中的数据的例子

今天的例子中给出一种比较方便的操作方法：要修改数据点击这一行－》鼠标放在哪个文本框就会选中哪个文本框的内容，直接可以进行修改－》修改完毕以后双击这一行（也可以直接双击文本框）进行保存。这次使用sqlserver数据库中的northwind数据库中的Employees表作为例子。

<% @ Page language = " c# "  Codebehind = " WebForm87.aspx.cs "  AutoEventWireup = " false "  Inherits = " csdn.WebForm87 "   %>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"  >
< HTML >
     < HEAD >
         < title > WebForm87 </ title >
         < meta  content ="Microsoft Visual Studio .NET 7.1"  name ="GENERATOR" >
         < meta  content ="C#"  name ="CODE_LANGUAGE" >
         < meta  content ="JavaScript"  name ="vs_defaultClientScript" >
         < meta  content ="http://schemas.microsoft.com/intellisense/ie5"  name ="vs_targetSchema" >
         < LINK  href ="css.css"  type ="text/css"  rel ="stylesheet" >
     </ HEAD >
     < body >
         < form  id ="Form1"  method ="post"  runat ="server" >
             < asp:datagrid  id ="DataGrid1"  runat ="server"  AutoGenerateColumns ="False"  CellSpacing ="1"  BorderWidth ="0px"
                CellPadding ="5"  CssClass ="border"  DataKeyField ="EmployeeID" >
                 < ItemStyle  CssClass ="item" ></ ItemStyle >
                 < HeaderStyle  CssClass ="header" ></ HeaderStyle >
                 < Columns >
                     < asp:BoundColumn  DataField ="FirstName"  HeaderText ="FirstName" ></ asp:BoundColumn >
                     < asp:BoundColumn  DataField ="LastName"  HeaderText ="LastName" ></ asp:BoundColumn >
                     < asp:BoundColumn  DataField ="Title"  HeaderText ="Title" ></ asp:BoundColumn >
                     < asp:BoundColumn  DataField ="BirthDate"  HeaderText ="BirthDate"  DataFormatString ="{0:yyyy-MM-dd}" ></ asp:BoundColumn >
                     < asp:ButtonColumn  ButtonType ="LinkButton"  CommandName ="edit"  Text ="edit"  Visible ="False" ></ asp:ButtonColumn >
                     < asp:ButtonColumn  ButtonType ="LinkButton"  CommandName ="update"  Text ="update"  Visible ="False" ></ asp:ButtonColumn >
                 </ Columns >
             </ asp:datagrid >
         </ 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  csdn
... {
    public class WebForm87 : System.Web.UI.Page
    ...{
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
    
        private void Page_Load(object sender, System.EventArgs e)
        ...{
            if(!IsPostBack)
            ...{
                SetBind();
            }
        }

        private void SetBind()
        ...{
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strconn"]);
            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();            
        }

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

        }
        #endregion

        private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        ...{
            if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
            ...{
                e.Item.Attributes.Add("onclick","__doPostBack('"+((LinkButton)e.Item.Cells[4].Controls[0]).ClientID.Replace("__","$_")+"','')");
            }
            if(e.Item.ItemType==ListItemType.EditItem)
            ...{
                e.Item.Attributes.Add("ondblclick","__doPostBack('"+((LinkButton)e.Item.Cells[5].Controls[0]).ClientID.Replace("__","$_")+"','')");
                for(int i=0;i<4;i++)((TextBox)e.Item.Cells[i].Controls[0]).Attributes.Add("onmouseover","this.select()");
            }
        }

        private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        ...{
            if(e.CommandName=="edit")
            ...{
                this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
                SetBind();
            }
            if(e.CommandName=="update")
            ...{
                try
                ...{
                    SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strconn"]);
                    SqlCommand comm=new SqlCommand("update Employees set FirstName=@FirstName,LastName=@LastName,Title=@Title,BirthDate=@BirthDate where EmployeeID=@EmployeeID",conn);
                    SqlParameter parm1=new SqlParameter("@FirstName",SqlDbType.NVarChar,20);
                    parm1.Value=((TextBox)e.Item.Cells[0].Controls[0]).Text;
                    SqlParameter parm2=new SqlParameter("@LastName",SqlDbType.NVarChar,10);
                    parm2.Value=((TextBox)e.Item.Cells[1].Controls[0]).Text;
                    SqlParameter parm3=new SqlParameter("@Title",SqlDbType.NVarChar,20);
                    parm3.Value=((TextBox)e.Item.Cells[2].Controls[0]).Text;
                    SqlParameter parm4=new SqlParameter("@BirthDate",SqlDbType.DateTime);
                    parm4.Value=((TextBox)e.Item.Cells[3].Controls[0]).Text;
                    SqlParameter parm5=new SqlParameter("@EmployeeID",SqlDbType.Int);
                    parm5.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
                    comm.Parameters.Add(parm1);
                    comm.Parameters.Add(parm2);
                    comm.Parameters.Add(parm3);
                    comm.Parameters.Add(parm4);
                    comm.Parameters.Add(parm5);
                    conn.Open();
                    comm.ExecuteNonQuery();
                    conn.Close();
                }
                catch
                ...{
                    Response.Write("<script>alert('输入的数据格式有误');</script>");
                }
                finally
                ...{
                    this.DataGrid1.EditItemIndex=-1;
                    SetBind();
                }
            }
        }

    }
}

这里有几点要注意的：编辑和修改时Visible="False",

e.Item.Attributes.Add("onclick","__doPostBack('"+((LinkButton)e.Item.Cells[4].Controls[0]).ClientID.Replace("__","$_")+"','')");        这代码是点击编辑时的代码。

 e.Item.Attributes.Add("ondblclick","__doPostBack('"+((LinkButton)e.Item.Cells[5].Controls[0]).ClientID.Replace("__","$_")+"','')");
                for(int i=0;i<4;i++)((TextBox)e.Item.Cells[i].Controls[0]).Attributes.Add("onmouseover","this.select()");
这里是加上点击修改时的代码。