过程或函数'SearchTestName'需要参数'@TestName',这是未提供的。 [英] Procedure or function 'SearchTestName' expects parameter '@TestName', which was not supplied.
本文介绍了过程或函数'SearchTestName'需要参数'@TestName',这是未提供的。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我收到此错误<<过程或函数''SearchTestName''需要参数''@TestName'',这是未提供的。>>
使用存储过程和c#代码在我的表中搜索值。
T-SQL:
< span class =code-keyword> CREATE PROC [dbo]。[SearchTestName]
@TestName nvarchar ( 50 )
AS
BEGIN
SELECT * FROM 测试其中(TestName like ' %' + @ TestName + ' %');
END
c#code:
< pre> protected void Seach_Onclick(object sender,EventArgs e)
{
sqlcon。 Close ();
sqlcon。打开();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable ds = new DataTable();
尝试
{
SqlCommand sqlcom = new SqlCommand( [ SearchTestName],sqlcon);
sqlcom.Parameters。添加( @ TestName,SqlDbType。 NVarChar , 50 )。Value = txtSearchTestName。文本跨度> .Trim();
adapter.SelectCommand = sqlcom;
adapter.Fill(ds);
labelSearch。文本 = 找到数据! 跨度>;
Response.Redirect( ConnectionString.aspx,true);
}
catch(exception ex)
{
labelSearch。 Text = ex的ToString();
}
}
我要做的是在文本框中输入一个值然后点击按钮搜索,我必须从表格测试中获取数据。
请有人帮忙修复此
解决方案
做类似的事情:
SqlParameter dataParameter = new SqlParameter();
dataParameter.Value = 50;
dataParameter.ParameterName =@ TestName;
SqlCommand cmd = new SqlCommand(([SearchTestName],sqlcon);
SqlDataReader reader = null;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(dataParameter);
conn.Open();
reader = cmd.ExecuteReader();
你好,
替换你的这个
SqlDataAdapter适配器= new SqlDataAdapter();
DataTable ds = new DataTable();
SqlCommand sqlcom = new SqlCommand( selectdata,sqlcon);
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add( new SqlParameter( name, Juhi Paunikar));
ds.Load(sqlcom.ExecuteReader());
sqlcon.Close();
我错过了我的代码中第-4行的行命令。
Hi, I am getting this error<<Procedure or function ''SearchTestName'' expects parameter ''@TestName'', which was not supplied.>>
when trying to search value in my table using a stored procedure and c# code.
T-SQL:
CREATE PROC [dbo].[SearchTestName]
@TestName nvarchar(50)
AS
BEGIN
SELECT * FROM Test where (TestName like '%'+ @TestName +'%');
END
c# code:
<pre> protected void Seach_Onclick(object sender, EventArgs e)
{
sqlcon.Close();
sqlcon.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable ds = new DataTable();
try
{
SqlCommand sqlcom = new SqlCommand("[SearchTestName]", sqlcon);
sqlcom.Parameters.Add("@TestName", SqlDbType.NVarChar, 50).Value = txtSearchTestName.Text.Trim();
adapter.SelectCommand = sqlcom;
adapter.Fill(ds);
labelSearch.Text = "Data Found!";
Response.Redirect("ConnectionString.aspx", true);
}
catch (Exception ex)
{
labelSearch.Text = ex.ToString();
}
}
What I am trying to do is to enter a value in a textbox then when hit on the button Search,I must get the data from the table test.
Please can someone help fixing this
解决方案
Do something like this:
SqlParameter dataParameter = new SqlParameter(); dataParameter.Value = 50; dataParameter.ParameterName = "@TestName"; SqlCommand cmd = new SqlCommand(("[SearchTestName]", sqlcon); SqlDataReader reader = null; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(dataParameter); conn.Open(); reader = cmd.ExecuteReader();
Hello,
Replace your with this
SqlDataAdapter adapter = new SqlDataAdapter(); DataTable ds = new DataTable(); SqlCommand sqlcom = new SqlCommand("selectdata", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add(new SqlParameter("name", "Juhi Paunikar")); ds.Load(sqlcom.ExecuteReader()); sqlcon.Close();
you are missed the line command type -4th line in my code.
这篇关于过程或函数'SearchTestName'需要参数'@TestName',这是未提供的。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文