when i type declare it does not show in the intellisense list so i can select if

Skullptor 0

I keep getting the error must declare scalar variable "@SerialNo". Doesn't make any sense because the variable is a txt variable. This is occuring while trying to save to a sql database - cmd.Parameters.AddWithValue("@txtSerialNnumber", txtSerialNo.Text);

Viorel 118.4K Reputation points

2024-05-13T14:35:20.0033333+00:00

The expectations are probably exaggerated. Show some details about the SQL code.
Skullptor 0 Reputation points

2024-05-13T21:54:46.89+00:00

Does this screen shot help.
Olaf Helper 45,291 Reputation points

2024-05-14T05:46:36.7533333+00:00

There is no screenshot. Better post the code as code text.
Skullptor 0 Reputation points

2024-05-14T10:08:14.94+00:00
Viorel 118.4K Reputation points

2024-05-14T10:15:21.26+00:00

It seems that the SQL statement, executed on SQL server by cmd.ExecuteNonQuery, contains an undeclared variable or parameter: @txtSerialNo. Maybe you should add it with cmd.Parameters.AddWithValue.

Or show details about the SQL statement.
Skullptor 0 Reputation points

2024-05-15T00:07:29.5266667+00:00

It's very difficult to find a solution to scalar errors on the internet. All I can find is that I need to declare the scalar to "variable". I even commented out that line of code and I still get the error for the same variable, which makes no sense at all. When I type the word declare it does not appear in the IntelliSense member list so I can't use it. I've spent days on trying to figure this out and it makes me angry when microsoft's software throws these kind of errors and you can't find a solution. If you can't help that's okay. I'll just have to figure out a way around it.

Share via

when i type declare it does not show in the intellisense list so i can select if

Your answer