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