Incorrect syntax near parameter (C# with SQL)

Question

I've got a problem that's driving me crazy. I get an exception "Incorrect syntax near "@p1" " when I'm inserting data into my database.

I looked for solutions on the internet but nothing solved this problem so far. Does anyone have a clue what is wrong with my code? Thanks! (By the way, sorry for some foreign language in code. It's a school project and the school that I'm attending is not english)

See also INSERT INTO, the 2nd example is really what you should be writing as specifying the column names is best practice. Otherwise your statement breaks or you will get unexpected results if your table schema ever changes (ie. column order changes). — Igor
– Igor, Commented Mar 12, 2017 at 11:01

Sadique · Accepted Answer · 2017-03-12 10:51:41Z

3

You got your insert syntax wrong, it should be:

INSERT INTO Leti VALUES ( @p1,@p2,@p3,.....)
                        ^                  ^
                        |-you missed these-|

answered Mar 12, 2017 at 10:51

Sadique

22.8k7 gold badges68 silver badges92 bronze badges

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

Comments

Prabha Rajan · Accepted Answer · 2017-03-12 15:51:26Z

1

Your insert statement should be like this :
      INSERT INTO

INSERT INTO Leti VALUES (@p1,@p2,@p3,@p4);

answered Mar 12, 2017 at 15:51

Prabha Rajan

681 silver badge4 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near parameter (C# with SQL)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related