UPDATE命令OleDb的问题 [英] Problems with the UPDATE command OleDb

问题描述

我仍然在acces数据库应用程序上工作，我对UPDATE命令有一个令人沮丧的问题:

Hay the Im still working on the acces database app and I have a little yet frustating problem with the UPDATE command :

 OleDbDataAdapter ap =  new OleDbDataAdapter();
 methods m = new methods();
 OleDbCommand c;

string command = ("UPDATE Users SET Id = ?, User = ? WHERE Id = ?");
            c = new OleDbCommand(command, con);
            c.Parameters.Add(password, OleDbType.VarChar, 14, password);
            c.Parameters.Add(user, OleDbType.VarChar, 25, user);
            c.Parameters.Add(Opassword, OleDbType.VarChar, 14, user);
ap.UpdateCommand = c;
            con.ConnectionString = conection;
            con.Open();
            ap.UpdateCommand.ExecuteNonQuery();

CON是数据库连接(已经完成)，我试图连接到ACCESS数据库.mdb

忘记了SYNTAX UPDATE COMMAND错误

CON is the database connection(its already done), Im trying to connect to a ACCESS database .mdb

Igot the SYNTAX ON UPDATE COMMAND error

推荐答案

用户是关键字. [用户]是您要寻找的.最好在表/字段名前后加上[]

User is a keyword. [User] is what you are looking for. It''s a good practice to surround table/field names with []

试试这个

Hi,
Try this

OleDbDataAdapter ap =  new OleDbDataAdapter();
methods m = new methods();
OleDbCommand c;

string command = ("UPDATE Users SET Id = @id, User = @user WHERE Id = @id");
c = new OleDbCommand(command, con);
c.Parameters.Add("@id", OleDbType.VarChar, 14, "<id>");
c.Parameters.Add("@user", OleDbType.VarChar, 25, "<user>");
ap.UpdateCommand = c;
con.ConnectionString = conection;
con.Open();
ap.UpdateCommand.ExecuteNonQuery();

这篇关于UPDATE命令OleDb的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！