存储过程调用 [英] store procedure call

问题描述

我已经创建了存储过程来调用select语句，但是给出了错误

i have create stored procedure to call select statement,but gives error

Procedure or function ''sp_selectvalidateusr'' expects parameter ''@Name'', which was not supplied.

请帮助新的sql



商店程序在下面

pls help m new to sql

store procedure is below

create PROCEDURE [dbo].[sp_selectvalidateusr] @Name nvarchar(50)
AS
SELECT *
FROM dance.Registration
WHERE Name = @Name

这里是代码

here is code

protected void TxtUserName_TextChanged(object sender, EventArgs e)
   {
       if (!string.IsNullOrEmpty(TxtUserName.Text))
       {
           SqlConnection con = new SqlConnection(GetConnectionString());
           con.Open();
           SqlCommand cmd = new SqlCommand("sp_selectvalidateusr", con);
           cmd.Parameters.AddWithValue("@Name", TxtUserName.Text);
           SqlDataReader dr = cmd.ExecuteReader();
           if (dr.HasRows)
           {
               checkusername.Visible = true;

               imgstatus.ImageUrl = "Images/NotAvailable.jpg";
               lblStatus.Text = "UserName Already Taken";

           }
           else
           {
               checkusername.Visible = true;
               imgstatus.ImageUrl = "Images/Icon_Available.gif";
               lblStatus.Text = "UserName Available";

           }
       }
       else
       {
           checkusername.Visible = false;
       }
   }

推荐答案

试试这个：

Hi,

Try this:

SqlConnection con = new SqlConnection(GetConnectionString());
con.Open();
SqlCommand cmd = new SqlCommand("sp_selectvalidateusr", con);
cmd.CommandType = CommandType.StoredProcedure; // add this line
cmd.Parameters.AddWithValue("@Name", TxtUserName.Text);
SqlDataReader dr = cmd.ExecuteReader();

希望这会有所帮助。

Hope this helps.

这篇关于存储过程调用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！