我打算在C#中使用OleDbDataAdapter在Access数据库中插入数据,但是在INSERT INTO命令中出现消息语法错误的错误
BackgroundWorker worker = new BackgroundWorker();
OleDbDataAdapter dbAdapter new OleDbDataAdapter();
OleDbConnection dbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\PMS.mdb");
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.DoWork += InsertJob;
worker.ProgressChanged += InsertJobCompleted;
worker.RunWorkerAsync(args);
而InsertJob函数是:
private void InsertJob(object sender, DoWorkEventArgs e)
{
var args = (InsertJobArgs)e.Argument;
try
{
dbAdapter.SelectCommand = new OleDbCommand("SELECT * FROM Sheet", dbConnection);
dbAdapter.Fill(args.DataTable);
var builder = new OleDbCommandBuilder(dbAdapter);
var row = args.DataTable.NewRow();
row["UserName"] = args.Entry.UserName;
row["Password"] = args.Entry.Password;
args.DataTable.Rows.Add(row);
dbAdapter.InsertCommand = builder.GetInsertCommand();
dbAdapter.Update(args.DataTable);
builder.Dispose();
}
catch (Exception ex)
{
args.Exception = ex;
worker.ReportProgress(0, args);
return;
}
worker.ReportProgress(100, args);
}
我在网上收到错误消息: dbAdapter.Update(args.DataTable);
我尝试使用Visual Studio对其进行调试,发现所有InsertCommand参数值均为 null
我试图在调用之前通过此代码手动插入 dbAdapter.Update(args.DataTable);
dbAdapter.InsertCommand.Parameters[0].Value = args.Entry.UserName;
dbAdapter.InsertCommand.Parameters[1].Value = args.Entry.Password;
尝试这个:
行后立即
var builder = new OleDbCommandBuilder(dbAdapter);
加两行
builder.QuotePrefix = "[";
builder.QuoteSuffix = "]";
这将告诉OleDbCommandBuilder
将表名和列名包装在方括号中,从而产生INSERT命令,例如
INSERT INTO [TableName] ...
而不是默认形式
INSERT INTO TableName ...
如果任何表名或列名包含空格或“有趣”字符,或者在Access SQL中碰巧它们是保留字,则必须使用方括号。(在您的情况下,我怀疑您的表具有名为[Password]的列,并且PASSWORD
是Access SQL中的保留字。)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句