samedi 23 mars 2019

why my code is not reading the next condition in if statement

i have a problem my code is not reading the next condition in if statement pls help me i just a beginner .

MySqlCommand cmd = new MySqlCommand("Select * from admin where Username='" + txtuser.Text + "'  and Password='" + txtpass.Text + "' ", con);

dr = cmd.ExecuteReader();
if (dr.Read())
{


    if (txtuser.Text == dr["Username"].ToString() && txtpass.Text == dr["Password"].ToString())
    {

        this.Hide();
        Form f1 = new Form1();
        f1.Show();
    }
    else if (txtuser.Text != dr["Username"].ToString() && txtpass.Text == dr["Password"].ToString())
    {
        MessageBox.Show("Incorrect Username!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
        clear();
    }
    else if (txtuser.Text == dr["Username"].ToString() && txtpass.Text != dr["Password"].ToString())
    {
        MessageBox.Show("Incorrect Password!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
        clear();
    }
    else if (txtuser.Text == "" & txtpass.Text == "")
    {
        MessageBox.Show("Please Enter Username and Password!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);

    }
    else if (txtuser.Text == "" && txtpass.Text != "")
    {
        MessageBox.Show("Please Enter Username!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
        clear();
    }
    else if (txtuser.Text != "" && txtpass.Text == "")
    {
        MessageBox.Show("Please Enter Password!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
        clear();
    }
    else if (txtuser.Text != dr["Username"].ToString() && txtpass.Text != dr["Password"].ToString())
    {
        MessageBox.Show("Incorrect Username and Password!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
        clear();
    }

Aucun commentaire:

Enregistrer un commentaire