Calling Storeprocedure in c#

Question

0.00/5 (No votes)

See more:

Hi,
i have create one store procedure spLogin.this procedure check wheather user name and password exist or not if yes return 1 if not exist return -1

but i am entering right user name and password but the store procedure returning value -1 my qurey is below

C#

SqlCommand cmd = new SqlCommand("spLogin", open());
           cmd.CommandType = CommandType.StoredProcedure;

           cmd.Parameters.Add("@LoginName", SqlDbType.VarChar).Value = clsComm.LoginName;
           cmd.Parameters.Add("@Loginpassword ", SqlDbType.VarChar).Value = clsComm.Loginpassword;

           result=cmd.ExecuteNonQuery();

Please help me out

Posted 17-Jun-12 23:26pm

Pradhan Gagan

Updated 17-Jun-12 23:28pm

Prasad_Kulkarni

v2

Add a Solution

Comments

Savalia Manoj M 18-Jun-12 8:38am

Please write your spLogin here.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Manas Bhardwaj · Answer 1 · 2012-06-17T23:31:00

Solution 1

It would be better if you check in profiler [^]what you stored procedure actually returns. I am also wondering that you use ExecuteNonQuery, where as I would expect data to be returned. ExecuteNonQuery is usually used to perform a change in data such as UPDATE, INSERT or DELETE.

Posted 17-Jun-12 23:31pm

Manas Bhardwaj

Comments

Pradhan Gagan 18-Jun-12 5:33am

so what would be cmd.excutescalar()?

Ankur^\m/ 18-Jun-12 5:50am

Yes if you are returning a single value.

Ankur^\m/ 18-Jun-12 5:51am

I too guess it should be because of ExecuteNonQuery(). It returns number of rows affected.

Manas Bhardwaj 18-Jun-12 6:03am

Agree!

Ankur^\m/ 18-Jun-12 12:50pm

I think I missed clicking those stars on the right. Well it's never too late! :)

Pradhan Gagan 18-Jun-12 5:53am

ok

Prasad_Kulkarni 18-Jun-12 6:02am

5'ed!

Manas Bhardwaj 18-Jun-12 6:03am

thx!

dharan1990 · Answer 2 · 2012-06-17T23:53:00

Create a stored procedure that accepts the name as input ....From that name return the password of current name...Check if both the value in text box and the result from the procedure is same or not...

C#

string Password="";
SqlDataReader ObjReader=null;
SqlCommand cmd = new SqlCommand("spLogin", open());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@LoginName", TextBoxUserName.ToString());
ObjReader=cmd.ExecuteReader();
while(ObjReader.read())
{
   Password=ObjReader[0].toString();

}
if(Password==TextBoxPassword.toString())
{
    //User Exists;
}
else
{
    UserName are password wrong;
}

Prosan · Answer 3 · 2012-06-17T23:59:00

Solution 3

don't use result=cmd.ExecuteNonQuery();
in place of use
result=cmd.excutescalar();
than i hope your problem will sort out.

Posted 17-Jun-12 23:59pm

Prosan

Updated 18-Jun-12 0:01am

v2