how to redirect different user to different pages.

Question

In database i have usernamepassworddepartment. . 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

Sheikh parvaz · Answer

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); }

Jay Ahuja · Answer

hello sir i want simple coding..

Jay Ahuja · Answer

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); } }

Krishna Garad · Answer

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

Krishna Garad · Answer

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