Syntax error in INSERT INTO statement in asp.net

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();

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

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

try like this

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

cause: password is reserved word

Source

Method 2

try this

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();
dbConnection.Close();

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0