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

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