使用SqlCommandBuilder，对表进行更新操作，可是操作无效，急！！！！

[gwallan]

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataSet ds = new DataSet();
SqlConnection conn=new SqlConnection("server=LY;database=KQXXGLXT;uid=usoft;pwd=");
SqlDataAdapter ap = new SqlDataAdapter();
ap.SelectCommand = new SqlCommand("select * from Kqzdzbsjb", conn);
SqlCommandBuilder cb=new SqlCommandBuilder(ap);

ap.UpdateCommand=cb.GetUpdateCommand();
//ap.DeleteCommand=cb.GetDeleteCommand();
//ap.InsertCommand=cb.GetInsertCommand();

ap.Fill(ds,"showtable");
ap.Update(ds,"showtable");
DataGrid1.EditItemIndex=-1;
DataGrid1.DataBind();
}

[gwallan]

我改了一下
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection conn=new SqlConnection("server=LY;database=KQXXGLXT;uid=usoft;pwd=");
SqlDataAdapter ap = new SqlDataAdapter("select * from Kqzdzbsjb", conn);
SqlCommandBuilder cb=new SqlCommandBuilder(ap);

ap.UpdateCommand=cb.GetUpdateCommand();
ap.DeleteCommand=cb.GetDeleteCommand();
ap.InsertCommand=cb.GetInsertCommand();

ap.Update(ds,"showtable");
DataGrid1.EditItemIndex=-1;
DataGrid1.DataBind();
}
可是报错，名称“ds”在类或命名空间“showtable.table”中不存在

[极客行天下]

更新数据要这样吗？

[海峰]

试试这个：
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataSet ds = new DataSet();
SqlConnection conn=new SqlConnection("server=LY;database=KQXXGLXT;uid=usoft;pwd=");
SqlDataAdapter ap = new SqlDataAdapter(("select * from Kqzdzbsjb", conn);
ap.Fill(ds,"showtable");
ap.Update(ds,"showtable");
DataGrid1.EditItemIndex=-1;
DataGrid1.DataBind();
}

[goodbegin]

我没测试过，但看了有点不解，ap.Fill(ds,"showtable")是填充数据，ap.Update(ds,"ShowTable")是更新数据，中间没有变化当然就不更新了，你这个ds是新建的，和DataGrid1所绑定的好象没什么关系

[gwallan]

楼上说的有道理，怎么把前面用的ds传到private void DataGrid1_UpdateCommand里面？

[goodbegin]

你这个ds是从哪里来的？是在以前绑定到DataGrid上的ds吗？你把ds的来历贴出来看看