Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

how to find user_type in asp.net?

Anonymous User 2239 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

Anonymous User

Other

I am a content writter !

1 Answers

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

MindStick Training