SELECT STATMENT错误 [英] SELECT STATMENT error

问题描述

我正在尝试将项目的名称从id 5添加到按钮文本，并从id 5图像作为按钮图像，这是错误



The参数化查询'（@ Nasiv nvarchar（8），@ slika nvarchar（4000））SELECT Naziv = @ Naziv，Sl'期望参数'@slika'，这是未提供的。



我尝试过：

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:

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

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

推荐答案

从一个更简单的查询开始：

Start with a simpler query:

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

并使用SqlDataReader或SqlDataAdapter读取数据。请参阅此处，例如代码：连接打开并关闭，如何正确使用？ [ ^ ]



但这不起作用：

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.

这篇关于SELECT STATMENT错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！