问题:使用GridView的GridView1_RowUpdating函数时无法更新数据,总是显示为原来的值
原因:点击“更新”按钮时页面会重新加载,这样会覆盖你所修改的值
解决方案:在Page_Load函数中加入如下判断,即把涉及到数据库操作的都要放到if判断里面。
if (!IsPostBack)
{
search();
}
功能:如果不是初次加载页面,则不执行search()函数,这样就可以保留你修改的值。
相关代码:
//使用GridView自带的“编辑”功能
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
search();//重新绑定数据,否则无法编辑选定的行
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string DeptInId = GridView1.DataKeys[e.RowIndex].Value.ToString();
string DeptCode = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString();
string sql = "update DeptIn set DeptCode = '" + DeptCode + "' where DeptInId = '" + DeptInId + "'"; //sql语句中必须注意要加上限定条件where语句。
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper cmd = db.GetSqlStringCommandWrapper(sql);
db.ExecuteNonQuery(cmd);
GridView1.EditIndex = -1;//退出编辑状态
search();
}
protected void search() {
string sql = "select * from DeptIn";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper cmd = db.GetSqlStringCommandWrapper(sql);
DataSet ds = new DataSet();
ds = db.ExecuteDataSet(cmd);
GridView1.DataSource = ds;
GridView1.DataBind();
}