private void showButton_Click(object sender, EventArgs e)
{
string query = "";
query =
String.Format(
"Select * From TbAfterManufactureStockOut Where StockOutDate >='{0}' AND StockOutDate < '{1}'",
fromDateTimePicker.Value.Date, toDateTimePicker.Value.Date.AddDays(1));
if (query != "")
{
SqlConnection conn = new SqlConnection(this.connectionString);
SqlCommand comm = new SqlCommand(query, conn);
SqlDataAdapter adap = new SqlDataAdapter();
StockOutDataSet dataset = new StockOutDataSet();
DateToDateStockOutCrystalReport crp = new DateToDateStockOutCrystalReport();
try
{
conn.Open();
adap.SelectCommand = comm;
adap.Fill(dataset, "DataTable1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}
crp.SetDataSource(dataset);
crystalReportViewer1.ReportSource = crp;
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DateToDateStockOutCrystalReport rpt = new DateToDateStockOutCrystalReport();
rpt.Site = this.Site;
return rpt;
}
