private void button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("execute salesDateRangeBal @fdate,@tdate", con);
da.SelectCommand.Parameters.AddWithValue("@fdate", textBox1.Text);
da.SelectCommand.Parameters.AddWithValue("@tdate", textBox2.Text);
DataTable dt = new DataTable();
da.Fill(dt);
saleReportDateRange myreport = new saleReportDateRange();
myreport.SetDataSource(dt);
SaleReportView srv = new SaleReportView();
srv.crystalReportViewer1.ReportSource = myreport;
srv.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "errorr!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
saleReportDateRange rpt = new saleReportDateRange();
rpt.Site = this.Site;
return rpt;
}