how to redirect different user to different pages.

Jay Ahuja

13y3.6k.NET

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..

m not getting how i wl do this..

reply asap.. m waiting

thank You

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Garad13y ago
Change the code like bellow

protected void btn_login_Click(object sender, EventArgs e)
{
string department;

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)
{
department=DS.Tables[0].Rows[0][0].ToString();
if(department=="IT")
Response.Redirect("ITPage.aspx");
else if(department=="HR")
Response.Redirect("HRPage.aspx");
else if(department=="Emp")
Response.Redirect("EmpPage.aspx");
else
//invalid user
}

}

0
Jay Ahuja13y ago
hello sir i want simple coding..
0
Sheikh parvaz13y ago
Dear friend,
if u really need to learn the authorisation of users then i will suggest you to go through the following link.
First you have to get the concept of the membership and roles of users. Then it will be very easy for you to manage the users and redirect them to their desired pages.

http://www.asp.net/web-forms/tutorials/security/membership/creating-the-membership-schema-in-sql-server-cs
http://www.asp.net/web-forms/tutorials/security/roles/creating-and-managing-roles-cs

Then the below code I am pasting which you will need later.

if (Roles.IsUserInRole(txtBox, "IT"))
{
HttpContext.Current.Response.Redirect("IT.aspx");
}

if (Roles.IsUserInRole(txtBox, "HR"))
{

HttpContext.Current.Response.Redirect("HR.aspx");
}
if (Roles.IsUserInRole(txtBox, "Employee"))
{
HttpContext.Current.Response.Redirect("Employee.aspx");
}

0
Jay Ahuja13y ago
hello sir thank for help my code is here can u please tell me where i to do change
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)
{
adp = new SqlDataAdapter(s, cn);
ds = new DataSet();
adp.Fill(ds);
return ds;
}


}
in
login.aspx.cs
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");
}

}

0
Krishna Garad13y ago
First you need to get the department from database for that you can write sql like
string sql="Select Department From TableName Where UserName='"+uname+"' and Password='"+password+"'";

Execute the above query and get the department from database after that check which department is reurned by above query.

if(department=="IT")
Response.Redirect("ITPage.aspx");
else if(department=="HR")
Response.Redirect("HRPage.aspx");
else if(department=="Emp")
Response.Redirect("EmpPage.aspx");
else
//invalid user
0