求教C#更新access数据库的问题
一个数据表的记录经过修改，想update，下面一段程序报错update语法错误。
代码如下：
public static void UpdateData(DataTable tbSource)
{
tbSource.TableName = "PreLogin";
OleDbConnection objConnection = new OleDbConnection(strmdb);
string linkage = "select * from [PreLogin] where [WorkID]<10 order by [WorkID] ASC";
OleDbDataAdapter sqlAdap = new OleDbDataAdapter(linkage, objConnection);
objConnection.Open();
OleDbCommandBuilder sqlBuilder = new OleDbCommandBuilder(sqlAdap);
sqlAdap.Update(tbSource); // 这一步报错
objConnection.Close();
}
