Gridview自定义编辑操作

Gridview自定义编辑操作，利用属性CommandName，CommandArgument来实现这种编辑的操作，对于更新，编辑，修改，取消，CommandName都有固定的关键字，分别为Update,Edit,Cancel.

前台代码如下：

  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" 
            onrowcancelingedit="GridView1_RowCancelingEdit" 
            onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">
            <Columns>
                <asp:BoundField DataField="CustomerID"  ReadOnly="true" HeaderText="CustomerID" />
                <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" />
                <asp:BoundField DataField="ContactName" HeaderText="ContactName" />
                <asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle" />
                <asp:TemplateField HeaderText ="编辑">
                    <ItemTemplate>
                        <asp:Button ID="Button1" runat="server" CommandName="Edit" CommandArgument='<%#Eval("CustomerID") %>'
                            Text="编辑" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:Button ID="Button2" runat="server" CommandName="Update" CommandArgument='<%#Eval("CustomerID") %>' Text="更新" />
                        <asp:Button ID="Button3" CommandName="Cancel" CommandArgument='<%#Eval("CustomerID") %>' runat="server" Text="取消" />
                    </EditItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

后台代码如下：

 protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {databind();
        }
    }
    public void databind()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ToString());
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Select * From Customers";
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.GridView1.DataSource = ds.Tables[0];
            this.GridView1.DataKeyNames = new string[]{"CustomerID"};
        this.GridView1.DataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        databind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        databind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string strKeys = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ToString());
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Update Customers Set CompanyName =@CompanyName ,ContactName=@ContactName,ContactTitle=@ContactTitle where CustomerID=@CustomerID";
        SqlParameter[] sp = new SqlParameter[4];
        sp[0] = new SqlParameter("@CompanyName",SqlDbType.NVarChar,40);
        sp[1] = new SqlParameter("@ContactName",SqlDbType.NVarChar,30);
        sp[2] = new SqlParameter("@ContactTitle",SqlDbType.NVarChar,30);
        sp[3] = new SqlParameter("@CustomerID",SqlDbType.NChar,5);
        sp[0].Value = ((TextBox)(this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim();
        sp[1].Value = ((TextBox)(this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.Trim();
        sp[2].Value = ((TextBox)(this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim();
        sp[3].Value = strKeys;
        cmd.Parameters.AddRange(sp);
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
        cmd.ExecuteNonQuery();
        this.GridView1.EditIndex = -1;
        databind();
    }