hi, how to create role based login in asp.net 4.5 ??

Question

hey guys,
i wanna create a one login page which will automatically redirect to specific page based on user role.because there is no membership provider in .net 4.5. but i have created users and user roles.:) how is it possible with .net 4.5??

Vincent Maverick Durano · Answer

The idea is to set the WHERE clause in your SQL query and pass the userID as the parameter Also I would suggest you to create a link table between your Users table and Roles table You could name the link table as UserRoles having these main fields: UserRoleID UserID RoleID You could then query your table and do the logic like this: using (SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE")) { string sql = "SELECT RoleID FROM UserRoles WHERE UserID= @UserID"; using (SqlCommand cmd = new SqlCommand(sql, connection)) { connection.Open(); cmd.Parameters.AddWithValue("@UserID", "Pass the IDhere"); using(var adapter = new SqlDataAdapter(cmd)){ adapter.Fill(dt); if (dt.Rows.Count > 0){ int roleID = Convert.ToInteger(dt.Rows[0][0].ToString()); if(roleID.Equals(1)) Response.Redirect("~/Admin.aspx"); else Response.Redirect("~/User.aspx"); } } } }

Abhineet Srivastava · Answer

Yeah..... You have to do some your custome logic to do so

Saineshwar Bageri · Answer

Check out this link will sure help you. http://www.c-sharpcorner.com/UploadFile/4d9083/creating-custom-role-manager-with-dynamic-menus-in-Asp-Net/

Saineshwar Bageri · Answer

same way u need to implement User Roles just remove menu part from it.

Tharindu N Chathuranga · Answer

Sainershwar : Thanks Bro. I'll try this method in my next project.cuz i have already created static menus for different pages. :)

Saineshwar Bageri · Answer

check out records in table have you fired all scripts. Marks as Answer if i have solved you problem

hi, how to create role based login in asp.net 4.5 ??

Answers (6)