GridView列表模式转到编辑模式
下面是一个比较完整的例子:
选 中gridview再属性上选择事件,触发以下操作
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();//自定义绑定数据的函数
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.GridView1.EditIndex = e.NewEditIndex;
BindData();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int i = this.GridView1.EditIndex;
string firstName = ((TextBox)(GridView1.Rows[i].Cells[5].Controls[0])).Text.ToString();
DataKey key = this.GridView1.DataKeys[e.RowIndex];
int id = int.Parse(key[0].ToString
/*
* 连接数据库,提交更新的资料
*/
SqlConnection uptCon = DB.createConnection();
uptCon.Open();
SqlCommand cmd = new SqlCommand( "update employees set FirstName= ' " + firstName + " ' where employeeID= " + id,uptCon);
cmd.ExecuteNonQuery();
Response.Write( "更新成功 ");
this.GridView1.EditIndex = -1;
BindData();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.GridView1.EditIndex = -1;
BindData();
}