Syntax Error In Insert Statement SQL C#

Question

I'm having trouble with the df.ExecuteNonQuery(); claiming that the insert statement has SQL errors. I'm not sure why the other parts of the program is working with the Insert statement, but the student one just refuses to work.
Database: http://puu.sh/hoTCv/c1ccb77551.png

OleDbCommand df = new OleDbCommand("INSERT into Students(ID,Password,FirstName,LastName,Street,City,State,Zip,EMail,GPA)" + "VALUES (?,?,?,?,?,?,?,?,?,?)", db);
//creating parameters
df.Parameters.AddWithValue("@ID", iDText.Text);
df.Parameters.AddWithValue("@Password", PassText.Text);
df.Parameters.AddWithValue("@FirstName", fnText.Text);
df.Parameters.AddWithValue("@LastName", LnText.Text);
df.Parameters.AddWithValue("@Street", StreetText.Text);
df.Parameters.AddWithValue("@City", CityText.Text);
df.Parameters.AddWithValue("@State", StateText.Text);
df.Parameters.AddWithValue("@Zip", ZipText.Text);
df.Parameters.AddWithValue("@EMail", EmailText.Text);
df.Parameters.AddWithValue("@GPA", GPAText.Text);
df.ExecuteNonQuery();
db.Close();

Password is a reserved keyword. It must be escape [Password]. — John Woo
– John Woo, Commented Apr 24, 2015 at 6:19

Soner Gönül · Accepted Answer · 2015-04-24 06:21:11Z

1

Password is a reserved keyword in Microsoft OLE DB Provider. You need to use square brackets like [Password]. As a best practice, change your column name to non-reserved word.

Also don't use AddWithValue method. It may generate unexpected results. Use .Add() overloads to specify your OleDbType and your parameter size.

And would be better to use using statement to dispose your OleDbConnection and OleDbCommand automatically instead calling .Close() or .Dispose() methods manually.

answered Apr 24, 2015 at 6:21

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Comments

Arion · Accepted Answer · 2015-04-24 06:20:21Z

0

Can this:

INSERT into Students(ID,Password ....

To this:

INSERT into Students(ID,[Password] ....

answered Apr 24, 2015 at 6:20

Arion

31.3k10 gold badges74 silver badges89 bronze badges

2 Comments

Rahul Nikate Over a year ago

@Sorry Don't forget to mark it as an answer, if it helped you. This way you will give reputation to person, who helped you

Sorry Over a year ago

Yes, I can't mark a answer into 9 minutes after its been asked.

Rahul Nikate · Accepted Answer · 2015-04-24 06:22:02Z

0

Password is a reserved keyword. Wrap your password like [Password]

Microsoft SQL Server uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the Transact-SQL language that is used by SQL Server to parse and understand Transact-SQL statements and batches. Although it is syntactically possible to use SQL Server reserved keywords as identifiers and object names in Transact-SQL scripts, you can do this only by using delimited identifiers.

answered Apr 24, 2015 at 6:22

Rahul Nikate

6,3555 gold badges45 silver badges57 bronze badges

Collectives™ on Stack Overflow

Syntax Error In Insert Statement SQL C#

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related