forum

Home / DeveloperSection / Forums / how to find user_type in asp.net?

Ask Question

how to find user_type in asp.net?

Anonymous User 1908 10-Nov-2014
I have login page with users having 3 user typs. from login im capturig user id and password. but i want to check user_type field and depending on that redirect to diferent pages after login. please advice me
asp.net c#  sql server  session 
Updated on 11-Nov-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

11-Nov-2014

You have to do something like this if you want to read from DB.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString);
    con.Open();
    SqlCommand cmd = new SqlCommand("SELECT User_Type FROM [User] WHERE User_Id =@userid and
User_Password=@password", con);
    cmd.Parameters.AddWithValue("@userid",Convert.ToInt32(txtUserName.Text));
    cmd.Parameters.AddWithValue("@password",txtPassword.Text);
    var reader = cmd.ExecuteReader();
    if (reader.HasRows)
    {
    reader.Read();
    string userType =reader.GetString(0);
        Session["USER_ID"]= txtUserName.Text;
        Response.Redirect("Default.aspx");
    }
    else
    {
        Response.Write("Login Failed");
    } 

Liked By