private void imprimer_adv_cause_Load(object sender, EventArgs e) { if (cn.State == ConnectionState.Closed) { cn.Open(); } cmd = new SqlCommand("Select [id_adversaire_cause] as[مرجع ],[type_adv] as[النوع],[cin_adv] as[ر.ب.و],[nom_adv] as[الاسم],[adjoint_adv] as[نائب الخصم],[representant_legal_adv] as[الممثل القانوني],[registre_commerce_adv] as[السجل التجاري],[adresse_adv] as[العنوان] from adversaire_cause where id_adversaire_cause like '" + id + "%'", cn); da = new SqlDataAdapter(cmd); da.Fill(ds, "adversaire"); cmd1 = new SqlCommand("select top(1)*from avocat", cn); da1 = new SqlDataAdapter(cmd1); da1.Fill(ds, "avocat"); if (type == "طبيعي") { repAdv i = new repAdv(); i.SetDataSource(ds); crystalReportViewer1.ReportSource = i; } if (type == "معنوي") { repAdv1 i = new repAdv1(); i.SetDataSource(ds); crystalReportViewer1.ReportSource = i; } cn.Close(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { repAdv1 rpt = new repAdv1(); rpt.Site = this.Site; return(rpt); }