向access数据库插入数据提示插入语法错误

[airjordan0923]

protected void Button1_Click(object sender, EventArgs e)
{
string a, b;
a = this.TextBox1.Text;
b = this.TextBox2.Text;
string con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("bank.mdb");
OleDbConnection myConnection = new OleDbConnection(con);

OleDbCommand myCommand = new OleDbCommand("Insert into secret(user,passwd) values('"+a+"','"+b+"')",myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}

[cpp2017]

try:

user==>[user]

[littlehand]

把 字符串 "Insert into secret(user,passwd) values('"+a+"','"+b+"'" 输出下吧..

PS:做Access的数据库操作是非常头痛的,莫名其妙的就出来个错误,而同样的语句在mssql中是正确的

[lutianling521]

[Quote=引用 1 楼 cpp2017 的回复:]
try:

user==>[user]
[/Quote]
up

[Snowdust]

OleDbCommand myCommand = new OleDbCommand("Insert into [secret]([user],[passwd]) values('"+a+"','"+b+"')",myConnection);
因为User是Access中的关键字，需要加上中括号。