Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have create stored procedure to call select statement,but gives error

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


pls help m new to sql

store procedure is below
SQL
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;
       }
   }
Posted
Updated 6-Apr-13 2:28am
v2

1 solution

Hi,

Try this:
C#
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.
 
Share this answer
 
Comments
AmitGajjar 6-Apr-13 8:30am    
perfect 5+
Thomas Daniels 6-Apr-13 8:31am    
Thank you!
Master Vinu 6-Apr-13 8:32am    
thx dear
Thomas Daniels 6-Apr-13 8:32am    
You're welcome!

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900