C # if statement (parameter read from sql server DB

Question

0.00/5 (No votes)

See more:

Good day all,

I am a beginner in programing and I can't get the below code to function properly.

when I use the two Response.write(role)statements, the code executes fine but when I comment them and use Response.write("users page") and Response.write("admins Page"), I always get the response: "admins page".

can someone please help and explain why this is happening?

C#

myCon.Open();
 
                        SqlCommand com3 = new SqlCommand("checkRole", myCon);
                        com3.CommandType = CommandType.StoredProcedure;
                        com3.Parameters.AddWithValue("@uName", TBoxUName.Text);
                        String role = com3.ExecuteScalar().ToString();
 
                        myCon.Close();
 

 
                        if (role == "user")
                        {
 
                            Response.Write("Users Page");
 
                            //Response.Write(role);

                        }
 
                        else
                        {
 
                            //Response.Write(role);
                            Response.Write("Admins Page");
 
                        }

Posted 28-Feb-14 8:45am

Member 10633743

Updated 28-Feb-14 9:08am

PIEBALDconsult

v2

Add a Solution

Comments

vv_shameer 28-Feb-14 15:06pm

Are you sure? I don't think there is a problem with your code
Pls make sure your stored procedure is not giving the same vslue everytime.
If everything is fine from SP and this is the code you are tesing with, it should work perfectly

1 solution

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)

BillWoodruff · Answer 1 · 2014-02-28T09:06:00

1. Put a break-point on the line: if (role == "user")

2. Run your application, and carefully examine the contents of the variable 'role. Do the contents appear to be "user" ?

3. Open a command window and examine the length of the contents of 'role: ? role.Length;

It's obvious that the contents of 'role are never equal to the string "user" : there could be a special character in the variable 'role. If the 'Length of the contents of 'role is not equal to #4, that would confirm that hypothesis.