private void Submit_btn_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
string conStr = ConfigurationManager.ConnectionStrings["coonstring"].ToString();
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("PurchaseReturnReportFetch", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FromDate", FromdateTimePicker.Value);
cmd.Parameters.AddWithValue("@ToDate", TodateTimePicker.Value);
da.SelectCommand = cmd;
da.Fill(dt);
PurchaseReturnReport report = new PurchaseReturnReport();
report.SetDataSource(dt);
crystalReportViewer_purchasereturn.ReportSource = report;
crystalReportViewer_purchasereturn.Refresh();
}
private void btnReportPurchaseReturn_Click(object sender, EventArgs e)
{
PurchaseReturnReport PurReturnReport = new PurchaseReturnReport();
PurReturnReport.ShowDialog();
}
