public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
adherentsCrystalReports rpt = new adherentsCrystalReports();
rpt.Site = this.Site;
return(rpt);
}
private void imprimerAdherents_Click(object sender, EventArgs e)
{
try
{
connection.Open();
DataTable adherentsTable = new DataTable();
new SqlDataAdapter($"select codAdh,nomAdh,cinAdh,dnAdh from adherents where dnAdh between" +
$" '{Date_De.Text}' and '{Date_A.Text}'; ", connection).Fill(adherentsTable);
adherentsCrystalReports adherentReports = new adherentsCrystalReports();
adherentReports.SetDataSource(adherentsTable);
adherentReports.SetParameterValue("date_de", Date_De.Text);
adherentReports.SetParameterValue("date_a", Date_A.Text);
crystalReportViewer1.ReportSource = adherentReports;
}catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}
