現有一數據集﹐如何通過OleDbDataAdapter控件使它更新至數據庫中?
我使用如下源碼﹐不知為什么沒能插入成功記錄?
ds為一已經存在的記錄集。
......
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand("select empid,eduyear,fromdate,todate from EduScoreDiscount",con);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(adapter);
adapter.InsertCommand = custCB.GetInsertCommand();
DataSet dss = new DataSet();
con.Open();
adapter.Fill(dss);
dss.Merge(ds,true);
adapter.Update(dss);
con.Close();
我使用如下源碼﹐不知為什么沒能插入成功記錄?
ds為一已經存在的記錄集。
......
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand("select empid,eduyear,fromdate,todate from EduScoreDiscount",con);
OleDbCommandBuilder custCB = new OleDbCommandBuilder(adapter);
adapter.InsertCommand = custCB.GetInsertCommand();
DataSet dss = new DataSet();
con.Open();
adapter.Fill(dss);
dss.Merge(ds,true);
adapter.Update(dss);
con.Close();
加这个参数看看 Customers -> 你的表名
public void Merge(
DataSet dataSet,
bool preserveChanges,
MissingSchemaAction missingSchemaAction
);ds.Merge(t2,false,MissingSchemaAction.Add);可能是你的两个数据集并不完全兼容吧