dataset未解决的问题再提问

[ddggggdd]

要实现的功能是事先先将数据插到dataset中,在一起更新 代码如下:

private void Button5_Click(object sender, System.EventArgs e)
{
DataSet InsertedRows = new DataSet() ;
System.Data.OleDb.OleDbConnection cnn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connection"]);
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter("select * from users",cnn);
DataSet ds = (DataSet)this.ViewState["ds"];
InsertedRows = ds.GetChanges(System.Data.DataRowState.Added) ;
ds.AcceptChanges();
da.Fill(InsertedRows,"users");
OleDbCommandBuilder MyCommandBuild = new OleDbCommandBuilder(da);
da.UpdateCommand = MyCommandBuild.GetUpdateCommand();
da.InsertCommand = MyCommandBuild.GetInsertCommand();
da.Update(InsertedRows,"users") ;
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}

其中DataSet ds = (DataSet)this.ViewState["ds"];中的ds就放着这些数据,可是当我再次绑定时纪录依然没有保存军数据库
请高手指教

[ddggggdd]

依然不可以，保存进dataset中了，可就是没有更新数据库
这个帖子好麻烦，看着没什么，可就是实现不了

[ddggggdd]

没人帮我吗

[jiezhi]

ds中有数据么？

[rickjelly2004]

修改后：：：



要实现的功能是事先先将数据插到dataset中,在一起更新 代码如下:

private void Button5_Click(object sender, System.EventArgs e)
{
DataSet InsertedRows = new DataSet() ;
System.Data.OleDb.OleDbConnection cnn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connection"]);
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter("select * from users",cnn);
DataSet ds = (DataSet)this.ViewState["ds"];
InsertedRows = ds.GetChanges(System.Data.DataRowState.Added) ;
ds.AcceptChanges();
OleDbCommandBuilder MyCommandBuild = new OleDbCommandBuilder(da);
da.Fill(InsertedRows,"users");

Da.Update(InsertedRows,"users") ;
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}


记住，数据库中要有主键

[CMIC]

把ds.AcceptChanges();移到Da.Update(InsertedRows,"users") ;或直接删除。

[bjbr]

up

[jingqiu5]

private void Button5_Click(object sender, System.EventArgs e)
{
DataSet InsertedRows = new DataSet() ;
System.Data.OleDb.OleDbConnection cnn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connection"]);
System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter("select * from users",cnn);
DataSet ds = (DataSet)this.ViewState["ds"];
InsertedRows = ds.GetChanges(System.Data.DataRowState.Added) ;
ds.AcceptChanges();
/*OleDbCommandBuilder MyCommandBuild = new OleDbCommandBuilder(da);
da.Fill(InsertedRows,"users");

Da.Update(InsertedRows,"users") ;
DataGrid1.DataSource = ds;
DataGrid1.DataBind(); */
}