Syntax error in INSERT INTO statement

Question

conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\database.mdb");
conn.Open();

com = new OleDbCommand(@"insert into group
                          (groupid,groupname,nature,effect) 
                         values 
                          (@groupid,@groupname,@nature,@effect)", conn);
com.Parameters.AddWithValue("@groupid", intialtxt);
com.Parameters.AddWithValue("@groupname", groupnametxt);
com.Parameters.AddWithValue("@nature", groupnaturecombo);
com.Parameters.AddWithValue("@effect", efectivegroupcombo);
com.ExecuteNonQuery();

conn.Close()

i have write this connection ,but i get one error Syntax error in INSERT INTO statement please someone help me.

Thomas Kjørnes · Accepted Answer · 2010-06-17 21:17:27Z

2

Wild guess, but try to type [group] instead of just group. I assume the group word is reserved because of the "GROUP BY" clause.

answered Jun 17, 2010 at 21:17

Thomas Kjørnes

1,9271 gold badge18 silver badges17 bronze badges

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

Comments

Serapth · Accepted Answer · 2010-06-17 21:21:57Z

1

Ahhh MS Access with your exceedingly stupid naming allowances, from allowing spaces in table names to permitting use of SQL keywords for field names.

GROUP is a SQL reserved word. If you have the chance, I highly recommend you rename it. That said, if you can't rename it, surround it with square brackets in the query [group].

answered Jun 17, 2010 at 21:21

Serapth

7,1824 gold badges33 silver badges39 bronze badges

Comments

rlb.usa · Accepted Answer · 2010-06-17 21:43:49Z

0

OleDbCommand(@"insert into group(

You have some typos:

there should be a space between the table name and your open paren, like this : group (groupid
.

edited Jun 17, 2010 at 21:43

answered Jun 17, 2010 at 21:17

rlb.usa

15.1k17 gold badges86 silver badges130 bronze badges

2 Comments

Jürgen Steinblock Over a year ago

The @ before a string is fine. It allows mulitline string in C# and you don't need to escape spacial characters. Extremly handy for regex and sql queries. i.e.: string pattern = @"\d+"; instead of string pattern = "\\d+";

Nate Dudek Over a year ago

"@" is actually valid where it is; it instructs the string to ignore escape codes. For example, it lets you put "\" in a string instead of forcing you to use the escape code of "\\".

Collectives™ on Stack Overflow

Syntax error in INSERT INTO statement

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related