Login Redirect Help with ASP.NET

Question

0.00/5 (No votes)

See more:

I need help with my log in page. I have a login page that every time I enter a username and password it goes black. The textboxes information are cleared out. What did I do wrong. What I am trying to do is to have one member with a level number to be redirected to one welcome page and the other user with another level number be directed to his/her welcome page. Please help me.

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PassConnectionString"].ConnectionString);
        con.Open();


            if (true)
            {
                string cmdStr3 = "select Password, accessLevel from TableSecurity where EmailAddress= '" + TextBoxEA.Text + "'";
                SqlCommand level = new SqlCommand(cmdStr3, con);
                
                SqlDataReader reader = level.ExecuteReader();
            DataTable dt1 = new DataTable();
            dt1.Load(reader);
 
            foreach (DataRow dr1 in dt1.Rows)
            {
                int returnedLevel = Convert.ToInt32(dr1[0].ToString());
                if (returnedLevel == 1)
                {
                    Response.Redirect("~/Secure.aspx");
                }
 
                else if (returnedLevel == 2)
                {
                    Response.Redirect("~/WelcomeIALO.aspx");
                }
            }
        }
        con.Close();
        }
    }

Posted 2-May-13 2:22am

Computer Wiz99

Updated 2-May-13 8:40am

Kenneth Haugland

v3

Add a Solution

Comments

Richard C Bishop 2-May-13 10:04am

Ok, can you post the structure and records of your new table. I am going to duplicate all of this in my application.

Computer Wiz99 2-May-13 10:25am

Ok. There three Tables. TableCEO, TableIALO, TableSecurity.

TableCEO:

INST_ID varchar(50) Unchecked
LastName varchar(50) Unchecked
FirstName varchar(50) Unchecked
MiddleName varchar(50) Checked
Prefix varchar(4) Unchecked
Suffix varchar(50) Checked
Salutation varchar(50) Checked
Title varchar(50) Unchecked
Address1 varchar(50) Unchecked
Address2 varchar(50) Unchecked
City varchar(50) Unchecked
State varchar(50) Unchecked
Zip numeric(18, 0) Unchecked
Country varchar(50) Checked
Phone numeric(18, 0) Unchecked
Fax numeric(18, 0) Unchecked
EmailAddress varchar(50) Unchecked
INST_CEO_I numeric(18, 0) Unchecked
Cell numeric(18, 0) Unchecked
LastUpdate datetime Checked
Level numeric(18, 0) Checked

TableIALO:
INST_ID varchar(50) Unchecked
LastName varchar(50) Unchecked
FirstName varchar(50) Unchecked
MiddleName varchar(50) Checked
Prefix varchar(4) Unchecked
Suffix varchar(50) Checked
Salutation varchar(50) Checked
Title varchar(50) Unchecked
Address1 varchar(50) Unchecked
Address2 varchar(50) Unchecked
City varchar(50) Unchecked
State varchar(50) Unchecked
Zip numeric(18, 0) Unchecked
Country varchar(50) Checked
Phone numeric(18, 0) Unchecked
Fax numeric(18, 0) Unchecked
EmailAddress varchar(50) Unchecked
LastUpdate datetime Checked
Level numeric(18, 0) Checked

TableSecurity:

INST_ID varchar(50) Checked
EmailAddress varchar(50) Unchecked
Password varchar(50) Unchecked
Level numeric(18, 0) Checked

The TableSecurity stores the username and password. The username is the emailaddress. The password is what the user comes up with and then stored in the TableSecurity. The program reads from TableCEO and TableIALO to make sure the user exist and can make a password. After the user makes the password and it is stored in the TableSecurity the program reads from that table in order to login the user.

Richard C Bishop 2-May-13 10:44am

Ok, I got it all to work. Can you list the data in the the TableSecurity table. I want to see what it looks like.

Computer Wiz99 2-May-13 11:00am

Ok. Here it is. This is what is in the TableSecurity.

INST_ID EmailAddress Password Level
10880 milholland@acu.edu iloveme 1
10880 schubert@acu.edu password 2

Richard C Bishop 2-May-13 11:03am

Ok, do this. Add "access" to the column name Level. "level" is a keyword in SQL. Next, see my solution below. It is only the redirecting part. We can tackle another issue next if you have it.

Computer Wiz99 2-May-13 11:12am

Ok. So on the TableSecurity name it accessLevel instead of Level. Then copy the updated code and debug it?

Richard C Bishop 2-May-13 11:13am

Yes, change the column name in your database. If that doesn't work now, it is because the pages you are trying to redirect to do not exist.

Computer Wiz99 2-May-13 11:19am

Why am I getting, The name 'TextBoxEA' does not exist in the current context?
I haven't started to debug yet.

Richard C Bishop 2-May-13 11:21am

You need to make sure the TextBox name in the code behind matches the HTML ID of the TextBox. That error means they are different.

Computer Wiz99 2-May-13 11:27am

Ok. I got that part fixed. So the user is not using the password any more to login?

Richard C Bishop 2-May-13 11:28am

We can change it to do that real easy. Did what we have redirect you now?

Computer Wiz99 2-May-13 11:30am

Ok. I have done that and the samething. Would you like to remote in my computer to see what I got? Do you use Teamviewer?

Richard C Bishop 2-May-13 12:09pm

Did the redirecting ever work with the first bit of code I gave you? Also, be sure to reply to my posts or else I won't be able to see them.

Computer Wiz99 2-May-13 12:11pm

NO the redirect did not work. How do I reply to your post? Did you want to remote in?

Richard C Bishop 2-May-13 12:14pm

You are not using the code I gave you in my solution then. I have a working replica of your application with no errors and it redirects prefectly. Use the "Improve question" widget and show me what you are using now. Just replace what is already there.

Computer Wiz99 2-May-13 12:19pm

I updated my code for compare. Tell me what I did wrong? Can you send it to me in a zip file?

Richard C Bishop 2-May-13 12:21pm

Remove "Password" from the query. We are not using that yet. If it does not redirect after you remove "Password" then Secure.aspx and WelcomeIALO.aspx do not exist. The code works prefectly as long as all the data is present.

Computer Wiz99 2-May-13 12:27pm

They do exist. I can show you by remote that way you can see for yourself. I can loadup Teamviewer.com and give yo the ID and password.

Richard C Bishop 2-May-13 12:28pm

We can try that.

Computer Wiz99 2-May-13 12:32pm

Ok. Go to Teamviewer.com and click on Join Remote Control Session under the big green download sign. Then run it.
My ID is 771 627 532. Let me know when you get there and I will send you the password.

Richard C Bishop 2-May-13 12:34pm

I am there.

Computer Wiz99 2-May-13 12:36pm

I'm sorry. Download the trail first. Right now you have a ID and password.

Richard C Bishop 2-May-13 12:41pm

Ok, I downloaded it, what is your id.

Computer Wiz99 2-May-13 12:29pm

Ok. You took password out. When I got to the login page and put in my username and password it goes blank. So, how is the user going to login using the password if it is not in the code?

Richard C Bishop 2-May-13 12:38pm

The login page is looking for an email address in order to redirect. If you are not using one of those email addresses in the table, it will not redirect.

Richard C Bishop 2-May-13 12:44pm

I deleted your phone number after I wrote it down so others would not see it.

Computer Wiz99 2-May-13 12:46pm

Ok. I can still see it.

Computer Wiz99 2-May-13 14:17pm

I'm back man. I tried to call but number went to someone else.

Richard C Bishop 2-May-13 14:21pm

Lol, woops sorry man. Want me to call you on the number you gave me?

Computer Wiz99 2-May-13 14:26pm

yeah.

Computer Wiz99 2-May-13 14:27pm

call me on this number. hold on

Richard C Bishop 2-May-13 14:35pm

http://www.codeproject.com/Articles/5719/Simple-encrypting-and-decrypting-data-in-C

Computer Wiz99 2-May-13 14:50pm

Thanks for your help!!

Richard C Bishop 2-May-13 14:53pm

You are welcome.

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)

Richard C Bishop · Accepted Answer · 2013-05-02T05:04:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;


public partial class _Default : System.Web.UI.Page
{
    protected void Button1_Click1(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PassConnectionString"].ConnectionString);
        con.Open();
 
        if (true)
        {
            SqlCommand level = new SqlCommand("select accessLevel, Password from TableSecurity where EmailAddress = @Email AND Password = @password", con);
            level.Parameters.Add(new SqlParameter("Email", TextBoxEA.Text));
            level.Parameters.Add(new SqlParameter("password", TextBoxPW.Text));

            SqlDataReader reader = level.ExecuteReader();
            DataTable dt1 = new DataTable();
            dt1.Load(reader);
 
            foreach (DataRow dr1 in dt1.Rows)
            {
                int returnedLevel = Convert.ToInt32(dr1[0].ToString());
                if (returnedLevel == 1)
                {
                    Response.Redirect("~/Default2.aspx");
                }
 
                else if (returnedLevel == 2)
                {
                    Response.Redirect("~/Default2.aspx");
                }
            }
        }
        con.Close();
    }
}