基本步骤：
1.在页面选择GridView空间
2.通过ADO.NET方法链接数据库。
3.在代码中，根据删除，编辑，取消，更新等按钮，执行相应的指定方法。
代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
namespace AspDB
{
??? public partial class _Default : System.Web.UI.Page
??? {
??????? protected void Page_Load(object sender, EventArgs e)
??????? {
??????????? if(!this.IsPostBack)//该段代码表示，当页面第一次加载的时候会绑定一次，当页面点更新的时候，一定要写该行代码，要不然就更新不了。因为点更新按钮后
??????????????????????????????? //没有该行，页面就重新获取原来的值了。
??????????? dbBind();
??????? }
??????? protected void Button1_Click(object sender, EventArgs e)
??????? {
??????????? MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection("Database='test';Data Source='localhost';User Id='root';Password='root';charset='utf8'");
??????????? MySqlCommand commend = new MySqlCommand("select * from user", con);
??????????? con.Open();
??????????
??????????? if (con.State == System.Data.ConnectionState.Open)
??????????? {
????????????
??????????????? MySqlDataAdapter msda = new MySqlDataAdapter("select * from user limit 50",con);
??????????????? DataSet ds = new DataSet();
??????????????? msda.Fill(ds);
??????????????? con.Close();
??????????????? this.GridView1.DataSource = ds;
??????????????? this.GridView1.DataKeyNames = new string[] { "ID" };
??????????????? this.GridView1.DataBind();
??????????? }
??????????? else
??????????? {
??????????????? Response.Write("<script>alert('数据库连接没打开。');</script>");
??????????? }
????????
??????? }
//该控件如果点击分页按钮，默认会触发PageIndexChanging方法
??????? protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
??????? {
??????????? this.GridView1.PageIndex = e.NewPageIndex;//通过点击页面的分页数字。传到后台的固定取值方法。
??????????? dbBind();
??????? }
??????? private void dbBind()
??????? {
??????????? MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection("Database='test';Data Source='localhost';User Id='root';Password='root';charset='utf8'");
??????????? MySqlCommand commend = new MySqlCommand("select * from user", con);
??????????? con.Open();
??????????? if (con.State == System.Data.ConnectionState.Open)
??????????? {
??????????????? MySqlDataAdapter msda = new MySqlDataAdapter("select * from user limit 50", con);
??????????????? DataSet ds = new DataSet();
??????????????? msda.Fill(ds);
??????????????? con.Close();
??????????????? this.GridView1.DataSource = ds;
??????????????? this.GridView1.DataKeyNames = new string[] { "ID"};//该段代码用来绑定你在删除或更新操作的时候，页面所传来的ID表示的是哪个字段。
??????????????? this.GridView1.DataBind();
??????????? }
??????????? else
??????????? {
??????????????? Response.Write("<script>alert('数据库连接没打开。');</script>");
??????????? }
??????? }
??????? //我们在GridView的列表中，选择旁边的按钮，然后选择"编辑列"，然后选择CommandField选择“删除”，就会出现删除的列，当点击删除的时候，会指定执行RowDeleting
??????? //方法，你双击事件中的该方法，然后开始写代码。
??????? protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
??????? {
??????????? string id = this.GridView1.DataKeys[e.RowIndex].Value.ToString();//指定写法，来得到页面传来的删除的ID值
??????????? //要选择GridView1.DataKeys[e.RowIndex].Value的时候，在绑定数据源的时候，一定要申明你绑定的值：this.GridView1.DataKeyNames = new string[] { "ID"};
??????????? MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection("Database='test';Data Source='localhost';User Id='root';Password='root';charset='utf8'");
??????????? string sql = "delete from user where id="+Convert.ToInt32(id);
??????????
??????????? con.Open();
??????????? MySqlCommand commend = new MySqlCommand(sql, con);
??????????? commend.ExecuteNonQuery();
??????????? con.Close();
??????????? this.dbBind();
??????? }
??????? //当点击编辑按钮，默认执行事件中的RowEditing方法
??????? protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
??????? {
??????????? //当选择编辑按钮，页面传入的ID值的取值方式固定写法。
??????????? this.GridView1.EditIndex = e.NewEditIndex;
??????????? this.dbBind();
??????? }
??????? //当点击取消按钮，默认执行事件中的RowCancelingEdit方法
??????? protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
??????? {
??????????? this.GridView1.EditIndex = -1;//当点击取消按钮，只要将EditIndex设置为-1；
??????????? this.dbBind();
??????? }
??????? protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
??????? {
??????????? MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection("Database='test';Data Source='localhost';User Id='root';Password='root';charset='utf8'");
//取值你要更新列的值。我的列的顺序为:删除，选择，ID,USERNAME,FLAG.
//我要更新的是username,flag，列是从0开始，所以选择的cell为第3列，和第4列。
//要取得你要更新列的指定写法。
??????????? string newName = ((TextBox)(this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.Trim();
??????????? string newFlag = ((TextBox)(this.GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.Trim();
??????????? string id = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
??????????? string sql = "update user set name='"+newName+"',flag='"+newFlag+"' where id="+Convert.ToInt32(id);
??????????? MySqlCommand command = new MySqlCommand(sql,con);
??????????? con.Open();
??????????? command.ExecuteNonQuery();
??????????? con.Close();
??????????? this.GridView1.EditIndex = -1;
??????????? this.dbBind();
??????? }
??? }
}