在INSERT的语法错误在asp.net声明 [英] Syntax error in INSERT INTO statement in asp.net

问题描述

我使用ASP.NET与MS.Access
在DATABSE ..有表称为登录有三个领域，即ID，用户名，密码。
以下是code这我试图运行。

I am using ASP.NET with MS.Access In databse.. there is table called login with three fields i.e. id, username, password. following is the code which i am trying to run.

String username = TextBox1.Text;
String password = TextBox2.Text;
OleDbConnection dbConnection = new OleDbConnection("provider=microsoft.ACE.OLEDB.12.0; Data source=C:\\Users\\Mohit Kumar Singla\\Documents\\phonebook.accdb");
dbConnection.Open();

Console.WriteLine("Error Occurred. Please check");
System.Diagnostics.Debug.WriteLine("Error--------------------------------");

String q = "insert into login (username, password) values (@u, @p)";               
OleDbCommand cmd = new OleDbCommand(q, dbConnection);

cmd.Parameters.AddWithValue("@u", username);
cmd.Parameters.AddWithValue("@p", password);

cmd.ExecuteNonQuery();

我得到这个错误，在INSERT INTO语句的语法错误。

I am getting this ERROR "Syntax error in INSERT INTO statement."

推荐答案

试试这样

String q = "insert into login (username, [password]) values (@u, @p)"; 

原因：密码保留字

<一个href=\"https://support.office.com/en-us/article/Access-2007-reserved-words-and-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe?ui=en-US&rs=en-US&ad=US\"相对=nofollow>来源

这篇关于在INSERT的语法错误在asp.net声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！