private void button5_Click(object sender, EventArgs e)
{
Close();
acceuilbon frm = new acceuilbon();
frm.Show();
}
private void button5_Click(object sender, EventArgs e)
{
//PREMIER METHODE POUR TESTER LE LOGIN
//MySqlConnection con = new MySqlConnection();
////con.ConnectionString = "server=localhost;database=nteko; uid=root;pwd=''";
//con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnServer"].ConnectionString;
//DataTable table = new DataTable();
//MySqlDataAdapter adapter = new MySqlDataAdapter();
//MySqlCommand cmd = new MySqlCommand("SELECT FROM 'utilisateur' WHERE 'Nom'=@Nom , 'Postnom'=@Postnom AND 'Password'=@Password" ,con);
//cmd.Parameters.Add("@Nom", MySqlDbType.VarChar).Value = textBox3.Text;
//cmd.Parameters.Add("@Postnom", MySqlDbType.VarChar).Value = textBox1.Text;
//cmd.Parameters.Add("@Password", MySqlDbType.VarChar).Value = textBox2.Text;
//try
// {
//con.Open();
//cmd.CommandType = CommandType.Text;
//cmd.Connection = con;
//adapter.SelectCommand = cmd;
//adapter.Fill(table);
//if (table.Rows.Count > 0)
//{
// Acceuil frm = new Acceuil();
// frm.Show();
//}
//}
// catch (MySqlException ex)
//{
// MessageBox.Show("Echec de la connection" + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
//finally
//{
// textBox3.Text = "";
// textBox2.Text = "";
// textBox1.Text = "";
// con.Close();
//}
//------------------------------------------------------------------------------------------------------------------------
//DEUXIEMME DETHODE POUR TESTER LE LOGIN: SEMPLE FACILE
con.Open();
cmd = new MySqlCommand("select* from administrateurs where PrenomAdmin= '" + textBox3.Text + "' AND Fonction ='" + textBox1.Text + "' AND PasswordAdmin= '" + textBox2.Text + "'", con);
MySqlDataReader dtr;
dtr = cmd.ExecuteReader();
if (dtr.HasRows)
{
acceuilbon frm = new acceuilbon();
frm.Show();
}
else
{
MessageBox.Show("Echec de la connection", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
textBox3.Text = "";
textBox2.PasswordChar = '*';
textBox1.Text = "";
con.Close();
//Code pour ferme le formulaire principale seul
this.Hide();
}
