How to solve error "Incorrect syntax near @parameter"?

Question

Why am i getting "incorrect syntax near @sqlFalse"?

The IsConnected column is defined as nvarchar.

Thanks.

SqlCommand cmd = new SqlCommand($"insert into clientstable (Name, NickName,isconnected) values (@sqlname,@sqlNickname ,@sqlFlase", sc);
cmd.Parameters.AddWithValue("@sqlName", textBoxName.Text);
cmd.Parameters.AddWithValue("@sqlNickname", textBox2.Text);
cmd.Parameters.AddWithValue("@sqlFalse", false);
int num = cmd.ExecuteNonQuery();

And I am not sure what happens when inserting a bool value (@sqlFalse) into a nvarchar column. — H.G. Sandhagen, Dec 22 '16 at 14:49
Don't edit your question to ask a new one. You are missing the closing parenthesis `...@sqlFalse)", sc)` — Pikoh, Dec 22 '16 at 14:49

score 1 · Answer 1 · edited May 23 '17 at 12:24

1

change this

values (@sqlname,@sqlNickname ,@sqlFlase", sc)

to this

values (@sqlname,@sqlNickname ,@sqlFalse", sc)

as Pelle mentioned in the comments

edited May 23 '17 at 12:24

Community

1
1

answered Dec 22 '16 at 14:49

stathis21098

31
13

score 0 · Answer 2 · answered Dec 22 '16 at 15:10

0

If you want to store a nvarchar but with false value the you should:

cmd.Parameters.AddWithValue("@sqlFalse", "false");

But probably you should change that type to Boolean.

answered Dec 22 '16 at 15:10

Juan

2,156
18
26

and consider @Pikoh comment, flag Don't edit your question to ask a new one. You are missing the closing parenthesis ... – Juan Dec 22 '16 at 15:12

score 0 · Answer 3 · answered Dec 22 '16 at 15:14

0

You are probably missing a ')' after @sqlFalse

Try to copy this and see if it helps.

SqlCommand cmd = new SqlCommand($"insert into clientstable (Name, NickName,isconnected) values (@sqlname,@sqlNickname ,@sqlFlase)", sc);

answered Dec 22 '16 at 15:14

Yawar Murtaza

3,655
5
34
40

How to solve error "Incorrect syntax near @parameter"?

3 Answers3