login by different role

saba naaz

8y1.2k.NET

Code for login-----

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{}

string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

string str, Email, Password;

SqlCommand com;

SqlDataAdapter sqlda;

DataTable dt;

int RowCount;

protected void ValidateUser(object sender, AuthenticateEventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

str = "Select Email,Password,Role from Users";

com = new SqlCommand(str);

sqlda = new SqlDataAdapter(com.CommandText, con);

dt = new DataTable();

sqlda.Fill(dt);

RowCount = dt.Rows.Count;

for (int i = 0; i < RowCount; i++)

{

Email= dt.Rows[i]["Email"].ToString();

Password = dt.Rows[i]["Password"].ToString();

if (Email==Login1.UserName && Password==Login1 .Password )

{

Session["Email"] = Email;

if (dt.Rows[i]["Role"].ToString() == "Admin")

Response.Redirect("Admin.aspx");

else if (dt.Rows[i]["Role"].ToString() == "User")

Response.Redirect("~/member.aspx");

}

else

{

Response.Redirect("Default.aspx");

}

table

UserId Firstname Lastname Email Contact Password Role

1 saba haque [email protected] 9876543210 12345 User

after entering the value in login form it opens Default.aspx..

not open member page

please help me

5 Replies

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

Sankara Krishnan Venugopal8y ago
Accepted answer
Technically, if your database value and input value has the same, it should work. I have verified it. Find the screenshot.

Thanks!
0
saba naaz8y ago
using this

if (Email.ToString().Trim() == Login1.UserName.ToString().Trim() && Password.ToString().Trim() == Login1.Password.ToString().Trim()) instead of
if (Email==Login1.UserName && Password==Login1 .Password ),

it is not working.still gives same issue.
+1
Sankara Krishnan Venugopal8y ago
Okay. Here you go.

Use this one if (Email.ToString().Trim() == Login1.UserName.ToString().Trim() && Password.ToString().Trim() == Login1.Password.ToString().Trim()) instead of
if (Email==Login1.UserName && Password==Login1 .Password )

Make sure you have used trim() function to remove empty spaces from the control to match table record(s).

And also, double check with the control and datatable records. If so, it works.

Hope this help. Thanks!
+1
saba naaz8y ago
https://www.aspsnippets.com/Articles/Assign-Roles-to-Users-in-ASPNet-Form-Based-Authentication.aspx

sir in this article same home page for user and admin..but in my project i want to give two different pages for admin and user..

https://www.c-sharpcorner.com/UploadFile/satyapriyanayak/registration-and-login-according-to-role-in-Asp-Net/

i am using above code for login,but i m unable to login..
+1
Vignesh Mani8y ago
https://www.c-sharpcorner.com/UploadFile/satyapriyanayak/registration-and-login-according-to-role-in-Asp-Net/

https://www.aspsnippets.com/Articles/Assign-Roles-to-Users-in-ASPNet-Form-Based-Authentication.aspx
+1