Call SQL Server stored procedure with parameters using C#

Question

I am trying to call a very simple SQL Server stored procedure using C# code. I have a class which has authenticate method. I am passing text box values (userID, password) to this method and it keeps on throwing me error about required parameter not being passed. I am basically a Business Intelligence professional working on C# project. Help will be appreciated.

Here is the code I am executing:

sqcon.Open();

SqlCommand cmd = new SqlCommand("Users.PR_Authenticate_WebUsers",sqcon);

cmd.Parameters.Add("@In_UserID", SqlDbType.VarChar).Value = "f";
cmd.Parameters.Add("@In_PassWord", SqlDbType.NVarChar).Value = "f";
cmd.Parameters.Add("@Out_IsAuthenticatedUser", SqlDbType.Bit);
cmd.Parameters["@Out_IsAuthenticatedUser"].Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery();
sqcon.Close();

I don't understand when I am passing parameter values explicitly why it complains about value not being passed? Am I missing something?

do u get some error ?? show us the full code

HEEN
– HEEN

2016-09-03 05:42:57 +00:00
Commented Sep 3, 2016 at 5:42 — HEEN
– HEEN, Commented Sep 3, 2016 at 5:42

marc_s · Accepted Answer · 2016-09-03 06:05:25Z

4

Hmmm looks like you are not telling the command object that it is a stored procedure not a regular query try this one

    sqcon.Open();
    SqlCommand cmd = new SqlCommand("Users.PR_Authenticate_WebUsers",sqcon);
    cmd.CommandType = CommandType.StoredProcedure;

    //Add parameters like this
    cmd.Parameters.Add(new SqlParameter("@In_UserID", "f"));
    sqcon.Close()

edited Sep 3, 2016 at 6:05

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Sep 3, 2016 at 5:02

Zain Ul Abidin

2,7601 gold badge23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Call SQL Server stored procedure with parameters using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related