Asp.net(C#)写的GridView更新代码:
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
string userid = GridView1.DataKeys[e.RowIndex].Value.ToString();//获取主键
GridViewRow myrow = GridView1.Rows[e.RowIndex];
string name = ((TextBox)myrow.Cells[1].Controls[0]).Text;//获取选中行单元格数据
string pwd = ((TextBox)myrow.Cells[2].Controls[0]).Text;
string sql = ”update dc4_user_def set username=’” + name + ”‘,password=’” + pwd + ”‘where userid=’” + userid + ”‘”;
DBHelper.ExcuteQuery(sql);
GridView1.EditIndex = -1;
this.BindGridView();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}