public void imprimer()
        {
            c.connecter();
            SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_conge='" + tnconge.Text + "'", c.con);
            DataSet        ds = new DataSet();

            da.Fill(ds, "conge");
            PRINTCONGE m = new PRINTCONGE();

            m.SetDataSource(ds);
            REPORTVIEW f = new REPORTVIEW(m);

            f.Show();
            c.deconnecter();
        }
        public void imprimer1()
        {
            c.connecter();
            SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_dote='" + tdot.Text + "'", c.con);
            DataSet        ds = new DataSet();

            da.Fill(ds, "conge");
            PRINTCONGEEXCEPTIONELE_NAISSENCE_A r1 = new PRINTCONGEEXCEPTIONELE_NAISSENCE_A();

            r1.SetDataSource(ds);
            REPORTVIEW f = new REPORTVIEW(r1);

            f.Show();
            c.deconnecter();
        }
        //imprimer 2
        public void imprimer2()
        {
            c.connecter();
            SqlDataAdapter da = new SqlDataAdapter(" select * from conge c inner join employe e on e.N_dote=c.N_dote where N_conge='" + tnconge.Text + "'", c.con);

            da = new SqlDataAdapter(" select * from employe e inner join conge c on e.N_dote=c.N_dote", c.con);
            DataSet ds = new DataSet();

            da.Fill(ds, "employe");
            da.Fill(ds, "conge");
            PRINTNAISSENCE PS = new PRINTNAISSENCE();

            PS.SetDataSource(ds);
            REPORTVIEW f = new REPORTVIEW(PS);

            f.Show();
            c.deconnecter();
        }
 private void bprint_Click(object sender, EventArgs e)
 {
     try
     {
         c.connecter();
         SqlDataAdapter da = new SqlDataAdapter("select * from employe e inner join conge c on e.N_dote=c.N_dote", c.con);
         da = new SqlDataAdapter("select * from conge c  inner join employe e on e.N_dote=c.N_dote where N_conge='" + tnconge.Text + "'", c.con);
         DataSet ds = new DataSet();
         da.Fill(ds, "employe");
         da.Fill(ds, "conge");
         c.deconnecter();
         PRINTCONGEANUEL pnt = new PRINTCONGEANUEL();
         pnt.SetDataSource(ds);
         REPORTVIEW f = new REPORTVIEW(pnt);
         f.Show();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }