public void imprimer()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_conge='" + tnconge.Text + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "conge");
CrystalReport2 m = new CrystalReport2();
m.SetDataSource(ds);
christal_report f = new christal_report(m);
f.Show();
con.Close();
}
public void imprimer1()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_dote='" + tdot.Text + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "conge");
report r1 = new report();
r1.SetDataSource(ds);
christal_report f = new christal_report(r1);
f.Show();
con.Close();
}
//mariage
public void mariage()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_dote='" + tdot.Text + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "conge");
Mariiage m = new Mariiage();
m.SetDataSource(ds);
christal_report f = new christal_report(m);
f.Show();
con.Close();
}
//imprimer 2
public void imprimer2()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(" select * from conge c inner join employe e on e.N_dote=c.N_dote where N_conge='" + tnconge.Text + "'", con);
da = new SqlDataAdapter(" select * from employe e inner join conge c on e.N_dote=c.N_dote", con);
DataSet ds = new DataSet();
da.Fill(ds, "employe");
da.Fill(ds, "conge");
report_F r2 = new report_F();
r2.SetDataSource(ds);
christal_report f = new christal_report(r2);
f.Show();
con.Close();
}
private void bprint_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from employe e inner join conge c on e.N_dote=c.N_dote", con);
da = new SqlDataAdapter("select * from conge c inner join employe e on e.N_dote=c.N_dote where N_conge='" + tnconge.Text + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "employe");
da.Fill(ds, "conge");
con.Close();
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(ds);
christal_report f = new christal_report(cr);
f.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
