SELECT STATMENT error

Question

1.00/5 (1 vote)

See more:

I am trying to get Name of the item from id 5 to the button text and from id 5 image as button image and this is the error

"The parameterized query '(@Naziv nvarchar(8),@slika nvarchar(4000))SELECT Naziv=@Naziv,Sl' expects the parameter '@slika', which was not supplied."

What I have tried:

C#

CON.Open();
string SQLQUERY = ("SELECT Naziv=@Naziv,Slika=@slika FROM HRANA WHERE Id='5'");
CMD = new SqlCommand(SQLQUERY, CON);
CMD.Parameters.AddWithValue("@Naziv", button24.Text);
CMD.Parameters.AddWithValue("@slika", button24.Image);
int N = CMD.ExecuteNonQuery();
CON.Close();

What am I doing wrong?

and when i am trying this

C#

CON.Open();
string SQLQUERY = ("SELECT Naziv=@Naziv FROM HRANA WHERE Id='5'");
CMD = new SqlCommand(SQLQUERY, CON);
CMD.Parameters.AddWithValue("@Naziv", button24.Text);

I am not getting any value

Posted 14-Aug-17 9:10am

Member 13084733

Updated 14-Aug-17 17:06pm

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 14-Aug-17 23:07pm

Naziv=@Naziv
Wrong order for one thing.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-08-14T09:25:00

Start with a simpler query:

string SQLQUERY = ("SELECT Naziv FROM HRANA WHERE Id='5'");
CMD = new SqlCommand(SQLQUERY, CON);

and use a SqlDataReader or SqlDataAdapter to read the data. See here for example code: Connection open and close, how to use correctly ?[^]

But this won't work:

CMD.Parameters.AddWithValue("@slika", button24.Image);

It won't transfer the image anywhere.
See here: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^] for how to deal with images and DBs.