|
string ptSqlStr = "select * from " + ptTableName + " where " + pesPointNum + " in(" + PipeUtility.MegerPesPointNames(pesPointName) + ") order by " + pesPointNum;
OleDbCommand command = new OleDbCommand(ptSqlStr);
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(ptSqlStr, connection);
DataSet ds = new DataSet();
adapter.Fill(ds,ptTableName);
string mSqlstr = "select * from " + ptTableName;
OleDbDataAdapter newAdapter = new OleDbDataAdapter();
OleDbCommand newCmd=new OleDbCommand(mSqlstr ,newConnection);
newAdapter.InsertCommand = newCmd;
OleDbCommandBuilder ff = new OleDbCommandBuilder(newAdapter);
try
{
newAdapter.Update(ds, ptTableName);
}
catch
{
出错:Update unable to find TableMapping['DSPOINT'] or DataTable 'DSPOINT'.
}
在更新另一个数据库时出错 错误原因为Update unable to find TableMapping['DSPOINT'] or DataTable 'DSPOINT' ,我在网上查了一下,也没有结果,请教是什么原因?
|
|