使用dataset更新行的问题

[wshlxvb]

private void update()
{
　string strid=Session["id"].ToString();
　string strconn="server=wshss;database=ASPNETOA;uid=sa;pwd=123";
　string strsql="select * from grmp where id="+strid;
　SqlConnection conn=new SqlConnection(strconn);
　SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
　DataSet ds =new DataSet();
　da.FillSchema(ds,SchemaType.Source,"grmp");
　da.Fill(ds,"grmp");
　DataTable dt=ds.Tables["grmp"];
　DataRow drow=dt.Rows.Find(strid);
　drow.BeginEdit();
　drow["name"]=txtname.Text.ToString().Trim();
　drow["sex"]=lstsex.SelectedItem.ToString();
　drow["birthday"]=Calendar1.Text.ToString();
　drow["duty"]=txtduty.Text.ToString().Trim();
　drow["comname"]=txtcomname.Text.ToString().Trim();
　drow["comaddress"]=txtcomaddress.Text.ToString().Trim();
　drow["compost"]=txtcompost.Text.ToString().Trim();
　drow["comtel"]=txtcomtel.Text.ToString().Trim();
　drow["comfax"]=txtcomfax.Text.ToString().Trim();
　drow["homeaddress"]=txthomeaddress.Text.ToString().Trim();
　drow["homepost"]=txthomepost.Text.ToString().Trim();
　drow["hometel"]=txthometel.Text.ToString().Trim();
　drow["handtel"]=txthandtel.Text.ToString().Trim();
　drow["email"]=txtemail.Text.ToString().Trim();
　drow["qqnumber"]=txtqqnumber.Text.ToString().Trim();
　drow.EndEdit();
　SqlCommandBuilder cb=new SqlCommandBuilder(da);
　da.Update(ds,"grmp");
｝
这个方法不报错，但是就是不能更新我选定的行，请高手赐教 }

[tsingfeng_bhcss]

更新后重新绑定数据库试试

[jingqiu5]

drow.BeginEdit();
drow.EndEdit();

我记得当时去掉了两句.
时间太长记不清了

[jingqiu5]

private void update()
{
　string strid=Session["id"].ToString();
　string strconn="server=wshss;database=ASPNETOA;uid=sa;pwd=123";
　string strsql="select * from grmp where id="+strid;
　SqlConnection conn=new SqlConnection(strconn);
SqlCommand command = New SqlCommand(strsql, conn)

　SqlDataAdapter da=new SqlDataAdapter(command);
　SqlCommandBuilder cb=new SqlCommandBuilder(da);

　DataSet ds =new DataSet();
　
　da.Fill(ds,"grmp");
　DataTable dt=ds.Tables["grmp"];
　DataRow drow=dt.Rows.Find(strid);
　drow.BeginEdit();
　drow["name"]=txtname.Text.ToString().Trim();
　drow["sex"]=lstsex.SelectedItem.ToString();
　drow["birthday"]=Calendar1.Text.ToString();
　drow["duty"]=txtduty.Text.ToString().Trim();
　drow["comname"]=txtcomname.Text.ToString().Trim();
　drow["comaddress"]=txtcomaddress.Text.ToString().Trim();
　drow["compost"]=txtcompost.Text.ToString().Trim();
　drow["comtel"]=txtcomtel.Text.ToString().Trim();
　drow["comfax"]=txtcomfax.Text.ToString().Trim();
　drow["homeaddress"]=txthomeaddress.Text.ToString().Trim();
　drow["homepost"]=txthomepost.Text.ToString().Trim();
　drow["hometel"]=txthometel.Text.ToString().Trim();
　drow["handtel"]=txthandtel.Text.ToString().Trim();
　drow["email"]=txtemail.Text.ToString().Trim();
　drow["qqnumber"]=txtqqnumber.Text.ToString().Trim();
　drow.EndEdit();

　da.Update(ds,"grmp");
｝