Different users access different page based on category and status from database in ASP.Net

Hi, micah,

I will get back to you soon.

Hi micah,

C#

 private void Redirect()
    {
        string Category = string.Empty;
        string userName = string.Empty;
        // set your login username value to this variable
        userName = "A";
        // userName = "B";
        // userName = "C";
        string constring = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constring))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM Category WHERE UserName = @UserName AND UPPER(Status) = 'TRUE'", con))
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("@UserName", userName);
                con.Open(); ;
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    Category = dr["Category"].ToString();
                }
                con.Close();
            }
        }

        if (!string.IsNullOrEmpty(Category))
        {
            Response.Redirect(Category + ".aspx");
        }
    }

Please you didn't use database as I explained on my daigram. Check my question again

micah says:

Please you didn't use database as I explained on my daigram. Check my question again

 1) As per your question Indresh replied to your question. You just need to pass the username value to check the category value as he already explained in code in comment after username variable check the variable and pass the value to the variable. 2) He used your same table as CATEGORY to select the Category if it matches with username. 3) In if case he already did the code for redirection if it match the user category from CATEGORY Table. 4) You just need to create the method and match the value from the select statement as he explained if you have changed you table structure then as per you have to change your logic. 5) Please check the code and understand it first so you can easily implement as per your requirement.