private void frmpaymentreport_Load(object sender, EventArgs e)
{
try
{
// RefreshCustomer();
PaymentReport rpt = new PaymentReport();
dsCommon ds = new dsCommon();
SQLiteConnection con = new SQLiteConnection("Data Source=" + System.IO.Path.Combine(AIO.path, AIO.file) + ";foreign keys=true;");//Password=5gs6hf7tjg86sjhfr6hkdg87grfj6ehgfr78lcmksd8;
AIO.command = CID;
SQLiteDataAdapter da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "Payment1");
AIO.command = "select abtComName as [Name],abtComAdd as [Add],abtComMob as [Mob],abtComEmail as [Email],abtVatTIN as [TIN],abtCstNo as [CST],abtPAN as [PAN],abtCIN as [CIN],abtEsta as [Esta] from AboutMe as [AM]";
da = new SQLiteDataAdapter(AIO.command, con);
da.Fill(ds, "AM");
rpt.SetDataSource(ds);
crvPyamentReport.ReportSource = rpt;
crvPyamentReport.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PaymentReport rpt = new PaymentReport();
rpt.Site = this.Site;
return(rpt);
}