使用GridView直接編輯更新數據時,出現一個讓我迷惑的問題:
GridView編輯更新后綁定的數據仍是未更新前的數據,而再次點擊編輯時才顯示更新后的數據,但當后臺數據是Oracle時,卻不會發生這種情況,這是為什么?
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e){ conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + base.Request.PhysicalApplicationPath + ConfigurationManager.AppSettings["AccessFile"]);
string sqlstr = "update ComputerList set Machine_ID='"??????????????? + ((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[1].Controls[0]).Text + "' where Computer_Name='"??????????????? + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
conn.Open();
?
cmd = new OleDbCommand(sqlstr, conn); cmd.ExecuteNonQuery(); GridView1.EditIndex = -1; bind(Session["GetDataSQL"].ToString());}
?
public void bind(string GetDataSQL){ string connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + base.Request.PhysicalApplicationPath + ConfigurationManager.AppSettings["AccessFile"]; conn = new OleDbConnection(connStr); conn.Open(); ds = this.StoneFunction.GetDSFromAccess(GetDataSQL, conn); DataView view = ds.Tables[0].DefaultView; GridView1.DataSource = view; GridView1.DataKeyNames = new string[] { "Computer_Name" }; GridView1.DataBind(); conn.Close();}
?
public override void VerifyRenderingInServerForm(Control control){}
- 4 回答
- 0 關注
- 457 瀏覽
添加回答
舉報
0/150
提交
取消