public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { ListePersonne rpt = new ListePersonne(); rpt.Site = this.Site; return(rpt); }
private void LoadReport() { if (ImplementeConnexion.Instance.Conn.State != ConnectionState.Open) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = @"select personne.id as Code,personne.nom + ' ' + ISNULL(personne.postnom,'') + ' ' + ISNULL(personne.prenom,'') as Nom, personne.sexe as Sexe,telephone.initial + '' + telephone.numero as 'Tél.' from personne left outer join telephone on personne.id=telephone.id_personne order by Nom asc "; SqlDataAdapter adapter = new SqlDataAdapter((SqlCommand)cmd); DataSet dataset = new DataSet(); adapter.Fill(dataset, "lstPersonne"); ListePersonne rpt = new ListePersonne(); rpt.SetDataSource(dataset.Tables["lstPersonne"]); crvRapport.ReportSource = rpt; crvRapport.Refresh(); dataset.Dispose(); } }