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

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