ASp.net C#.how to redirect different user to different pages.

Question

3.33/5 (3 votes)

See more:

In database i have username,password,department,..
while login time i have to check username and department(in department i have fields are IT, employee, HR )
if username and department(IT) it should b redirect to It Page only
if username and department(Hr) it should b redirect to HR Page only
if username and department(Employee) it should b redirect to Employee Page only

and login.aspx i have only two filed user name and password..

following is my coding

C#

public class LogIn
{
SqlDataAdapter adp;
DataSet ds;
public LogIn()
{

}
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["ConnectionString"].ConnectionString.ToString());

public DataSet select(string s)
{
adp = new SqlDataAdapter(s, cn);
ds = new DataSet();
adp.Fill(ds);
return ds;
}
}

in
login.aspx.cs

C#

protected void btn_login_Click(object sender, EventArgs e)
{
DataSet DS = new DataSet();
string s = "select depertment from checkuser where user_name='" + txtusername.Text + "' and password='" + txtpassword.Text + "'";
DS = objlog.select(s);

if (DS.Tables[0].Rows.Count > 0)
{
Session["username"] = txtusername.Text;
Response.Redirect("Home.aspx");
}

}

m not getting how i wl do this..
reply asap.. m waiting
thank You

Posted 21-Dec-12 20:21pm

Jay Ahuja

Updated 22-Dec-12 0:10am

Sandeep Mewara

v2

Add a Solution

4 solutions

Solution 3

C#

DataSet DS = new DataSet();

    string s = "select depertement from tb where username='" + TextBox1.Text + "' and password='" + TextBox2.Text + "'";

    DS = objlog.select(s);


    if (DS.Tables[0].Rows.Count > 0)
    {

        Session["username"] = TextBox1.Text;
        Session["depertementname"] = DS.Tables[0].Rows[0]["depertement"].ToString().ToUpper();

        if (Session["depertementname"].ToString() == ("HR"))
        {

            Response.Redirect("HrHome.aspx");

        }

        else
        {

            Response.Redirect("Home.aspx");

        }


    }
}

Posted 23-Dec-12 5:31am

Jay Ahuja

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)

pankaj986 · Accepted Answer · 2012-12-23T19:00:00

Namskar(Hi),

C#

protected void btn_login_Click(object sender, EventArgs e)
{
DataSet DS = new DataSet();
string s = "select depertment from checkuser where user_name='" + txtusername.Text + "' and password='" + txtpassword.Text + "'";
DS = objlog.select(s);

if (DS.Tables[0].Rows.Count > 0)
{
Session["username"] = txtusername.Text;
   if(DS.Tables[0].Rows[0][0].ToString()=="IT")
    {
      Response.Redirect("IT.aspx");
    }
   else if(DS.Tables[0].Rows[0][0].ToString()=="Employee")
    {
      Response.Redirect("Employee.aspx");
    }
   else
    {
      Response.Redirect("Hr.aspx");
    }


}

}

AnkitGoel.com · Accepted Answer · 2012-12-21T20:32:00

Solution 2

1. You have to store the user type in user table.
2. Verify that username and password are correct.
3. Get user type from database.
4. Open the appropriate page using if-else.

This is too basic solution.
Hope it helps.........

In case you are not satisfied with the solution please let me know.
I will tell you the other way.

[Edit]Shouting removed[/Edit]

Posted 21-Dec-12 20:32pm

AnkitGoel.com

Updated 22-Dec-12 0:13am

v2

Comments

Jay Ahuja 22-Dec-12 3:00am

hello sir, thanx for ur help
the 1st three step m already done wen m trying 4th one itz redirecting to same page only can u please help me for this

AnkitGoel.com 22-Dec-12 3:03am

send your code by which u are redirecting users to different pages

Jay Ahuja 22-Dec-12 3:14am

if (DS.Tables[0].Rows.Count > 0)
{
Session["username"] = txtusername.Text;
if (Session["username"].ToString() == ("Emplpoyee"))
{
Response.Redirect("Home.aspx");
}
else
{
Response.Redirect("HrHome.aspx");
}

}

AnkitGoel.com 22-Dec-12 3:17am

in this case which page are u getting redirected?

Also, check the spell mistake -emplpoyee- should be 'employee-

Jay Ahuja 22-Dec-12 3:19am

home.aspx

AnkitGoel.com 22-Dec-12 3:22am

try rebuilding your project. this prob should not occur if u are passing something other that 'emplpoyee' in username textbox.

Jay Ahuja 22-Dec-12 3:22am

i had try same for HR also doing geting same Rply

AnkitGoel.com 22-Dec-12 3:23am

i feel u need to debug your app and find out the reason

Jay Ahuja 22-Dec-12 3:23am

in textbox i m have passing username.. only and password in password textbox

AnkitGoel.com 22-Dec-12 3:24am

or i will have to review the complete code behind to be able to investigate the problem

AnkitGoel.com 22-Dec-12 3:25am

why have u kept "emplpoyee" in parentheses?

Jay Ahuja 22-Dec-12 3:25am

please try that sir.. m facing this prblm last 5 days

AnkitGoel.com 22-Dec-12 3:26am

send complete code pls..

Jay Ahuja 22-Dec-12 3:28am

in login.aspx.cs
DataSet DS = new DataSet();
string s = "select depertment from checkuser where user_name='" + txtusername.Text + "' and password='" + txtpassword.Text + "'";
DS = objlog.select(s);

if (DS.Tables[0].Rows.Count > 0)
{
Session["username"] = txtusername.Text;
Response.BufferOutput = true;

if (Session["username"].ToString() == "HR")
{
Response.Redirect("HrHome.aspx");
}
else
{
Response.Redirect("Home.aspx");
}

}
}
in class file i have
public class LogIn
{
SqlDataAdapter adp;
DataSet ds;
public LogIn()
{

}
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString());

public DataSet select(string s)
{
cn.Open();
adp = new SqlDataAdapter(s, cn);
ds = new DataSet();
adp.Fill(ds);
return ds;

}

}

Jay Ahuja 22-Dec-12 3:27am

if i don't keep in parentheses than also m geting same page

AnkitGoel.com 22-Dec-12 3:28am

tried debugging?

Jay Ahuja 22-Dec-12 3:28am

yup sir.. check my code

AnkitGoel.com 22-Dec-12 3:30am

please debug it and check the value in the textbox.

Jay Ahuja 22-Dec-12 3:36am

wen i debug it itz not checking this condtion
if (Session["username"].ToString() == "HR")
{
Response.Redirect("HrHome.aspx");
}

AnkitGoel.com 22-Dec-12 3:37am

check the condition before this.Are you able to authenticate the user?

Jay Ahuja 22-Dec-12 3:40am

ya.. according to u wat should b code.. can u please tel me that

AnkitGoel.com 22-Dec-12 3:41am

check the values at-

string s = "select depertment from checkuser where user_name='" + txtusername.Text + "' and password='" + txtpassword.Text + "'";

tell me what u get here?

Jay Ahuja 22-Dec-12 3:47am

had apply wat had given but geting username nd password only not depertement value

AnkitGoel.com 22-Dec-12 3:51am

i said u to check the value of textboxes at following line-
string s = "select depertment from checkuser where user_name='" + txtusername.Text + "' and password='" + txtpassword.Text + "'";
and u are teelling me some other thing.

Jay Ahuja 22-Dec-12 4:18am

m getting this sir
"select depertment from checkuser where user_name='jay' and password='111'"

AnkitGoel.com 22-Dec-12 4:21am

may be ur not getting any row from database for this qry. did u check?

Jay Ahuja 22-Dec-12 4:26am

hello sir can u please send me compelete code of my query??

Jay Ahuja 22-Dec-12 5:05am

sir please help me for this..

AnkitGoel.com 22-Dec-12 5:07am

dear, no one is free to do your work. we can only guide you. there is some bug that u have to resolve by urself. i can't do anything from here.

Jay Ahuja 22-Dec-12 5:09am

ohk sir thanx alot for helping me.. :)

AnkitGoel.com 22-Dec-12 5:11am

As per my understanding, your select query is not producing correct result. you need to check that query.

Jay Ahuja 22-Dec-12 5:17am

in checkuser table i have 4 coloum.. emp_id,username,password,depertment is there should prblm coz for this????

AnkitGoel.com 22-Dec-12 5:19am

how would i know that when i am unable to see ur db ?

Jay Ahuja 22-Dec-12 5:21am

ya.. wrong que.. sorry for this

Sajeesh Payolam · Accepted Answer · 2012-12-21T20:28:00

Solution 1

Read it
http://msdn.microsoft.com/en-us/library/540y83hx%28v=vs.100%29.aspx">http://msdn.microsoft.com/en-us/library/540y83hx%28v=vs.100%29.aspx">http://msdn.microsoft.com/en-us/library/540y83hx%28v=vs.100%29.aspx

Posted 21-Dec-12 20:28pm

Sajeesh Payolam

Comments

Jay Ahuja 22-Dec-12 5:55am

itz not help full sir can u tel wer is error in my coding part