private void button1_Click(object sender, EventArgs e)

        {
            try
            {
                utilisateur u = new utilisateur();


                Program.cnx.Open();

                Program.cmd.Connection = Program.cnx;

                Program.cmd.CommandText = "select loginsal ,motdepasse ,grade from salarie where  loginsal ='" + textBox_login.Text + "' and  motdepasse='" + textBoxmotpasse.Text + "' and grade ='manager' ";


                Program.dr = Program.cmd.ExecuteReader();



                if (Program.dr.Read())
                {
                    Form2 f2 = new Form2();



                    f2.Show();


                    this.Hide();
                }


                Program.cnx.Close();

                utilisateur u1 = new utilisateur();
                Program.cnx.Open();

                Program.cmd.Connection = Program.cnx;

                Program.cmd.CommandText = "select loginsal , motdepasse , grade from salarie where  loginsal ='" + textBox_login.Text + "' and  motdepasse='" + textBoxmotpasse.Text + "' and grade='salarie'";


                Program.dr = Program.cmd.ExecuteReader();
                if (Program.dr.Read())
                {
                    u1.Show();

                    this.Hide();
                }

                Program.cnx.Close();


                u1.dataGridView1.Visible = true;


                Program.cnx.Open();
                Program.cmd.Connection  = Program.cnx;
                Program.cmd.CommandText = "select nom, prenom , sexe , sitiationfami as sitiationfamilial , servis , echel , grade , nbrenfant as 'nomber enfant' , mh as 'masse horaire' , th as 'taux horaire' ,sb as 'salarie de basse' , cnss  , Ir ,Allocation , prime , sn as 'salaire Net' from salarie as s , bulltien as b where s.matricule = b.matricule  and  (s.loginsal='" + textBox_login.Text + "'  and s.motdepasse ='" + textBoxmotpasse.Text + "')";
                Program.dr = Program.cmd.ExecuteReader();



                DataTable dt = new DataTable();

                dt.Load(Program.dr);
                Program.dr.Close();
                Program.cnx.Close();
                u1.dataGridView1.DataSource = dt;


                u1.dataGridView2.Visible = true;
                connection c = new connection();


                Program.cnx.Open();
                Program.cmd.Connection  = Program.cnx;
                Program.cmd.CommandText = "select  numcongé , nom, prenom , sexe , typecongé ,datedebut , datfin , nomb as 'nomner des jours' ,etat  from salarie as s , congé as c where s.matricule = c.matricule  and  (s.loginsal='" + textBox_login.Text + "'  and s.motdepasse ='" + textBoxmotpasse.Text + "')";
                Program.dr = Program.cmd.ExecuteReader();

                DataTable dt1 = new DataTable();

                dt1.Load(Program.dr);
                Program.dr.Close();
                Program.cnx.Close();
                u1.dataGridView2.DataSource = dt1;
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }
        }