private void ReportDateWise_View__Load(object sender, EventArgs e)
{
SQLiteConnection con;
con = new SQLiteConnection("Data Source=./database/database.sqlite;datetimeformat = CurrentCulture;");
ReportAuthorWise rptAuth = new ReportAuthorWise();
// MessageBox.Show("" + rptAuth.authorwiseParameter);
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from issue1 where issueddaate >= '" + combQuery + "' and issueddaate <= '" + combQuery2 + "'", con);
ReportDocument cr = new ReportDocument();
cr.Load(Application.StartupPath + "\\Report\\bookissuance(datewise).rpt");
viewDataSet ds = new viewDataSet();
try
{
da.Fill(ds.issue1);
cr.SetDataSource(ds);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
private void ReportCupboardWise_View__Load(object sender, EventArgs e)
{
SQLiteConnection con;
con = new SQLiteConnection("Data Source=./database/database.sqlite;datetimeformat = CurrentCulture;");
ReportAuthorWise rptAuth = new ReportAuthorWise();
// MessageBox.Show("" + rptAuth.authorwiseParameter);
SQLiteDataAdapter da = new SQLiteDataAdapter("SELECT * from querybook where Regid='" + combQuery + "'", con);
ReportDocument cr = new ReportDocument();
cr.Load(Application.StartupPath + "\\Report\\listofbooks.rpt");
viewDataSet ds = new viewDataSet();
try
{
da.Fill(ds.querybook);
cr.SetDataSource(ds);
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
private void authorWiseToolStripMenuItem_Click(object sender, EventArgs e)
{
ReportAuthorWise athwise = new ReportAuthorWise();
athwise.ShowDialog();
}