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