OleDbDataAdapter.update的问题
我现在在作一个access和sqlserver互相导入的程序,两个数据库表结构完全一样。
在从access向sqlserver导时能成功导入,可是 从sqlserver往access导入时,发生错误
{"INSERT INTO 语句的语法错误。"}
不知道怎么纠错,请各位大虾指点。
代码如下:
OleDbDataAdapter dpSqlServer = new OleDbDataAdapter("select * from tablename", SqlServerConn);
DataSet dsSqlServer = new DataSet();
dpSqlServer.Fill(dsSqlServer );
DataSet dsAccess= new DataSet();
OleDbDataAdapter dpAccess = new OleDbDataAdapter("select * from tablename where 1=0", AccessConn);
dpAccess .Fill(dsAccess);
dsAccess= dsSqlServer ;
for (int j = 0; j < dsSqlServer.Tables[0].Rows.Count; j++)
{
dsAccess.Tables[0].Rows[j].SetAdded();
}
try
{
OleDbCommandBuilder cbAccess = new OleDbCommandBuilder(dpAccess);
//导入数据
dpAccess .Update(dsAccess);
}
catch{}