点击Update之后，更新不了数据。。。用Response.Write写出来后，却是如下面的样子。
void dg_Update(Object Sender,DataGridCommandEventArgs e)
{
datacon();
OleDbCommand thisCOMD=thisCN.CreateCommand();
thisCOMD.CommandText="Update students set class=@class,sex=@sex where id=@no";
thisCOMD.Parameters.Add("@class",((TextBox)e.Item.Cells[1].Controls[0]).Text);
thisCOMD.Parameters.Add("@class",((TextBox)e.Item.Cells[2].Controls[0]).Text);
thisCOMD.Parameters.Add("@no",((TextBox)e.Item.Cells[0].Controls[0]).Text);//id放在表格的第一列。
thisCOMD.Parameters["@no"].Value =dg.DataKeys [e.Item.ItemIndex];
Response.Write(""+thisCOMD.CommandText+"");//这句在浏览器中写出来的是：Update students set class=@class,sex=@sex where id=@no.
try
{
thisCOMD.ExecuteNonQuery();
}
catch
{
Response.Write("Sorry!");
}
thisCN.Close();
}

更新字符串有问题。

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string strconn= ConfigurationSettings.AppSettings["dsn"];
SqlConnection cn=new SqlConnection (strconn);
cn.Open();
string sql="Update users set UID=@UID , UPassword=@UPassword,UPower=@UPower,UQuestion=@UQuestion,UAnswer=@UAnswer,Email=@Email where ID=@ID";
SqlCommand cm=new SqlCommand (sql,cn);
cm.Parameters.Add("@ID",((TextBox)e.Item.Cells[2].Controls[0]).Text);
cm.Parameters.Add("@UID",((TextBox)e.Item.Cells[3].Controls[0]).Text);
cm.Parameters.Add("@UPassword",((TextBox)e.Item.Cells[4].Controls[0]).Text);
cm.Parameters.Add("@UPower",((TextBox)e.Item.Cells[5].Controls[0]).Text);
cm.Parameters.Add("@UQuestion",((TextBox)e.Item.Cells[6].Controls[0]).Text);
cm.Parameters.Add("@UAnswer",((TextBox)e.Item.Cells[7].Controls[0]).Text);
cm.Parameters.Add("@Email",((TextBox)e.Item.Cells[8].Controls[0]).Text);
cm.Parameters["@ID"].Value =DataGrid1.DataKeys [e.Item.ItemIndex];

try
{
cm.ExecuteNonQuery ();

}
catch (SqlException exc)
{

Label1.Text ="编辑失败;<br>原因："+exc.ToString ();
}
finally
{
String mysql="select* from users " ;
SqlDataAdapter dp = new SqlDataAdapter (mysql,cn);
DataSet ds=new DataSet();
dp.Fill (ds,"users");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
cn.Close ();
Label1.Text ="编辑成功。";
}
首先你在DataGrid的DataKeyFiled属性中填上要更改数据库表的主键，我这个就是“ID”既图片中的“编号”那一列。。

更新以后你在重新绑定一次。。。。。

[此贴子已经被作者于2006-11-20 10:47:58编辑过]

void dg_Update(Object Sender,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
datacon();
OleDbCommand thisCOMD=thisCN.CreateCommand();
thisCOMD.Parameters.Add("@no",((TextBox)e.Item.Cells[0].Controls[0]).Text);
thisCOMD.Parameters.Add("@class",((TextBox)e.Item.Cells[1].Controls[0]).Text);
thisCOMD.Parameters.Add("@sex",((TextBox)e.Item.Cells[2].Controls[0]).Text);
thisCOMD.Parameters["@no"].Value=dg.DataKeys[e.Item.ItemIndex];
thisCOMD.CommandText="Update students set mys=@mys,sex=@sex where id=@no";
try
{
thisCOMD.ExecuteNonQuery();
}
catch
{
Response.Write("Sorry");
Response.Write(""+thisCOMD.CommandText+"");
Response.Write(""+e.Item.ItemIndex+"");
}
finally
{
thisAdapter=new OleDbDataAdapter("Select * from students",thisCN);
thisDS=new DataSet();
thisAdapter.Fill(thisDS,"students");
dg.DataSource=thisDS;
dg.DataBind();
dg.EditItemIndex=-1;
}
thisCN.Close();
}

问题已解决，，谢谢大家，，