GridView中行的编辑与删除

（引用）

using System.Data.SqlClient;

public partial class_Default : System.Web.UI.Page

{

SqlConnection conn = new SqlConnection("Data Source=.;Initial

Catalog=MySql;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)//判定是否第一次加载，必须的，否则编辑中的数据更新不了

{

bind();

}

}

//绑定数据

public void bind()

{

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter("select * from student", conn);

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataKeyNames = new string[] { "id" };//设“id”为标识

GridView1.DataBind();

}

//删除当前行

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

string commString = String.Format("delete from student where id='{0}'",

GridView1.DataKeys[e.RowIndex ].Value .ToString ());//取出当前行的标识SqlCommand comm = new SqlCommand(commString,conn);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

bind();

}

//编辑当前行

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;//对所在行进行编辑

bind();

}

//更新编辑

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

string commString = String.Format("update student set

name='{0}',sex='{1}',age='{2}' where id='{3}'",

((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() ,//当前行的，第1列（从0开始），第0个控件

((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() ,

((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() ,

GridView1.DataKeys[e.RowIndex].Value.ToString());

SqlCommand comm = new SqlCommand(commString, conn);

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

GridView1.EditIndex = -1;//取消编辑

bind();

}

//取消编辑

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bind();

}

}

注：“Page_Load（）”中绑定的方法“bind（）”一定要有if (!IsPostBack){}包含，否则更

新数据将不可用。