SQL Insert statement not working C#

Question

Using Access database like this :

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + Request.PhysicalApplicationPath + "Resources/cars_db.accdb");
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO Users (Username, Password, Email, Address, Question, Answer) VALUES ('" + txtUsernameRP.Text + "','" + txtPasswordRP.Text + "','" + txtEmailRP.Text + "','" + txtAddressRP.Text + "','" + txtQuestionRP.Text + "','" + txtAnswerRP.Text + "')";
int i = cmd.ExecuteNonQuery(); -- **Breaks here and says syntax error**

I have tried:

Taking out the int i bit.
Putting the @ symbol in front of the statement.
Checked and made sure that I am using the Access code.
Tried closing the connection before creating in case it was something there.
Substituted the data for fixed values, which I then ran in a query in Access which worked.
Put the access query mentioned above into the code block (cmd.CommandText = "INSERT INTO Users (Username, Password, Email, Address, Question, Answer) VALUES ('asdasd','Asd!23asd','asdasd','asdasd','asdasd','asdasd')"; and tried running it and again same syntax error.

Please someone help me...

Do you have any specific syntax error (near line ...) ? Or just general syntax error? — KuKeC
– KuKeC, Commented Oct 20, 2015 at 9:19
You missed a paranteces in nr 6. i dont know if it matters but... — Daniel Stackenland
– Daniel Stackenland, Commented Oct 20, 2015 at 9:19

jLaw · Accepted Answer · 2015-10-20 10:02:09Z

2

Password is reserved keyword

  cmd.CommandText = "INSERT INTO Users (Username, Password, Email, Address...

try this

cmd.CommandText = "INSERT INTO Users (Username, [Password], Email, Address...

answered Oct 20, 2015 at 10:02

jLaw

3024 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roman Marusyk · Accepted Answer · 2015-10-20 09:29:00Z

0

Can You try this?

 "INSERT INTO Users (Username, Password, Email, Address, Question, Answer) 
    VALUES(
    '" + txtUsernameRP.Text + "',
    '" + txtPasswordRP.Text + "',
    '" + txtEmailRP.Text + "',
    '" + txtAddressRP.Text + "',
    '" + txtQuestionRP.Text + "',
    '" + txtAnswerRP.Text + "');";

edited Oct 20, 2015 at 9:29

Roman Marusyk

24.8k27 gold badges83 silver badges127 bronze badges

answered Oct 20, 2015 at 9:27

Naveen Bathina

4141 gold badge6 silver badges25 bronze badges

1 Comment

Naveen Bathina Over a year ago

I have tried removing "(Username, Password, Email, Address, Question, Answer)" and it works fine for me..

pruuylan · Accepted Answer · 2015-10-20 09:59:16Z

0

I guess your problem is on that int i, try removing it

answered Oct 20, 2015 at 9:59

pruuylan

861 gold badge1 silver badge10 bronze badges

Collectives™ on Stack Overflow

SQL Insert statement not working C#

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related