void dg_Cancel(Object Sender,DataGridCommandEventArgs e)
{
dg.EditItemIndex=-1;
dg.DataSource=thisDS;
dg.DataBind();
}
void dg_Update(Object Sender,DataGridCommandEventArgs e)
{
datacon();
int i=e.Item.ItemIndex;
TextBox thisBox=(TextBox)e.Item.FindControl("idbox");
thisDS.Tables["students"].Rows[i]["id"]=thisBox.Text;
thisBox=(TextBox)e.Item.FindControl("namebox");
thisDS.Tables["students"].Rows[i]["name"]=thisBox.Text;
thisBox=(TextBox)e.Item.FindControl("classbox");
thisBox=(TextBox)e.Item.FindControl("gradebox");
thisDS.Tables["students"].Rows[i]["grade"]=thisBox.Text;
thisBox=(TextBox)e.Item.FindControl("classbox");
thisDS.Tables["students"].Rows[i]["school"]=thisBox.Text;
thisBox=(TextBox)e.Item.FindControl("sexbox");
thisDS.Tables["students"].Rows[i]["sex"]=thisBox.Text;
OleDbCommandBuilder thisBD=new OleDbCommandBuilder(thisAdapter);
thisAdapter.SelectCommand.CommandText="Select * from students";
thisBD.RefreshSchema();
thisAdapter.UpdateCommand=thisBD.GetUpdateCommand();
thisAdapter.Update(thisDS,"students");
thisDS.Clear();
thisAdapter.Fill(thisDS,"students");
dg.DataSource=thisDS;
dg.DataBind();
}
在DataGrid中更新数据，但点击Upate命令之后，不会更新数据，，到底错在哪啊，请指教了。。。Thanks................

Select * from students where?

不晓得，我也看不大懂 = =+

String strSQL = "UPDATE grade SET "+
"姓名='"+((TextBox)E.Item.Cells[3].Controls[0]).Text
+"',数学="+((TextBox)E.Item.Cells[4].Controls[0]).Text
+" where 学号="+dg.DataKeys[(int)E.Item.ItemIndex];

Cells[3] Cells[4]中的3和4要改的.要看你的表怎么建了.

表名是grade
字段为"姓名","数学","学号"

这个只是sql语句,其余的还要你自己添加.

同意楼上的，thisAdapter.SelectCommand.CommandText="Select * from students where________";where后面还应该指定查询条件的吧

看看你的Page_Load事件中有没有做“!Page.IsPostBack”判断，没有的话肯定是更新不了的