错误sql dataadapter参数未提供 [英] error sql dataadapter parameter not supplied

问题描述

你好，
尝试从自定义选择语句执行参数时收到此错误.
在按钮中单击

Hello,
I get this error while I am trying to execute a parameter from a custom select statment.
In a button click

Me.SqlDataAdapter1.SelectCommand.CommandText = SELECT * FROM Table_1 WHERE surname LIKE +'%'+@sur+'%'
              Me.SqlDataAdapter1.SelectCommand.Parameters(0).Value = TextBox1.Text

当我尝试填充数据适配器时出现此错误，它仅在我在数据适配器设计器中插入预定义值时才起作用(我没有通过代码创建适配器.

谢谢
Kyriakos

And I get this error when I am trying to fill the dataadapter, it works only when I insert a predefined value in the dataadapter designer (I didn''t create the adapter through code.

Thank you
Kyriakos

推荐答案

在字符串之间不包含参数.在参数中包含％op.

Do not include parameters between strings. Include the % op within the param.

Me.SqlDataAdapter1.SelectCommand.CommandText = "SELECT * FROM Table_1 WHERE surname LIKE @sur"

Me.SqlDataAdapter1.SelectCommand.Parameters(0).Value = "%" & TextBox1.Text & "%"

-编辑-
如果发生错误，则可能尚未添加参数.尝试添加参数

--Edit--
If an error occurs, you may not have added the parameter. Try adding the parameter

Me.SqlDataAdapter1.SelectCommand.Parameters.AddWithValue("@sur", TextBox1.Text)

要转换为字符串的是int32.

Had to convert to string was an int32.

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