public int reviseDetail(DataSet ds,string tableName,string dsTableName)
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
int result=0;
string sql = "select * from " + tableName;
OleDbConnection conn = DBCon.getDBcon().getAccConn();
try
{
adapter.SelectCommand = new OleDbCommand(sql, conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(adapter);
conn.Open(); result = adapter.Update(ds,dsTableName);
}catch (Exception e)
{
MessageBox.Show(e.Message);
}
conn.Close();
return result;
}如上方法调用后,adapter.Update提示"至少一个参数没有被指定值",望指教。。
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
int result=0;
string sql = "select * from " + tableName;
OleDbConnection conn = DBCon.getDBcon().getAccConn();
try
{
adapter.SelectCommand = new OleDbCommand(sql, conn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(adapter);
conn.Open(); result = adapter.Update(ds,dsTableName);
}catch (Exception e)
{
MessageBox.Show(e.Message);
}
conn.Close();
return result;
}如上方法调用后,adapter.Update提示"至少一个参数没有被指定值",望指教。。
说明sql语句可能存在问题,仔细检查一下。
我试用这种方法,如有问题请多指教,谢谢。窗体B.DataSet dsB = 窗体A.DataSet dsA
窗体B.DataGridView1.DataSource =dsB.tables[0].defaultView;修改窗体B.DataGridView1, 然后使用 reviseDetail(DataSet ds,string tableName,string dsTableName)这个方法update