详解GridView自带的编辑删除更新功能

GridView自带编辑删除更新逻辑很简单：操作完，重新绑定。总结总结，防止忘记。。。
效果图：

前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridView_bianjidelete.aspx.cs" Inherits="gridView_bianjidelete" %><！DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title></title></head><body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit"><FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /><Columns> <asp:BoundField DataField="ID" HeaderText="产品ID" ReadOnly="True" /> <asp:BoundField DataField="name" HeaderText="产品name" /> <asp:BoundField DataField="stock" HeaderText="库存" /> <asp:CommandField HeaderText="选择" ShowSelectButton="True" /> <asp:CommandField HeaderText="编辑" ShowEditButton="True" /> <asp:CommandField HeaderText="删除" ShowDeleteButton="True" /></Columns><RowStyle ForeColor="#000066" /><SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="Red" /><PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /><HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /> </asp:GridView> </div> </form></body></html>

后台代码：

using System;using System.Collections.Generic;using System.Configuration;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class gridView_bianjidelete : System.Web.UI.Page{//清清月儿http://blog.csdn.net/21aspnet SqlConnection sqlcon; SqlCommand sqlcom; string strCon = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString; protected void Page_Load（object sender, EventArgs e） {if （！IsPostBack）{ bind（）;} } protected void GridView1_RowEditing（object sender, GridViewEditEventArgs e） {GridView1.EditIndex = e.NewEditIndex;bind（）; } //删除之后重新绑定 protected void GridView1_RowDeleting（object sender, GridViewDeleteEventArgs e） {string sqlstr = "delete from product where id="" + GridView1.DataKeys[e.RowIndex].Value.ToString（） + """;sqlcon = new SqlConnection（strCon）;sqlcom = new SqlCommand（sqlstr, sqlcon）;sqlcon.Open（）;sqlcom.ExecuteNonQuery（）;sqlcon.Close（）;GridView1.DataBind（）;bind（）; } //更新 protected void GridView1_RowUpdating（object sender, GridViewUpdateEventArgs e） {sqlcon = new SqlConnection（strCon）;string sqlstr = "update product set name="" + （（TextBox）（GridView1.Rows[e.RowIndex].Cells[1].Controls[0]））.Text.ToString（）.Trim（） + "",stock="" + （（TextBox）（GridView1.Rows[e.RowIndex].Cells[2].Controls[0]））.Text.ToString（）.Trim（） + "" where id="" + GridView1.DataKeys[e.RowIndex].Value.ToString（） + """;sqlcom = new SqlCommand（sqlstr, sqlcon）;sqlcon.Open（）;sqlcom.ExecuteNonQuery（）;sqlcon.Close（）;GridView1.EditIndex = -1;// GridView1.DataBind（）;bind（）; } //取消 protected void GridView1_RowCancelingEdit（object sender, GridViewCancelEditEventArgs e） {GridView1.EditIndex = -1;bind（）; } //绑定 public void bind（） {string sqlstr = "select * from product p,Uuser u where p.userid=u.id";sqlcon = new SqlConnection（strCon）;SqlDataAdapter myda = new SqlDataAdapter（sqlstr, sqlcon）;DataSet myds = new DataSet（）;sqlcon.Open（）;myda.Fill（myds, "datatable"）;GridView1.DataSource = myds;GridView1.DataKeyNames = new string[] { "id" };//主键GridView1.DataBind（）;sqlcon.Close（）; }}

以上就是本文的全部内容，希望本文的内容对大家的学习或者工作能带来一定的帮助，同时也希望多多支持脚本之家！