how to transfer data from datagridview to crystal report.
i done this given code but data is not display on crystal report.
- private void SalesReportPrint_Load(object sender, EventArgs e)
- {
- if (con.State == ConnectionState.Open)
- {
- con.Close();
- }
- con.Open();
- DataSetSalesReport dsr = new DataSetSalesReport();
- if (from!="" && to != "")
- {
- OleDbCommand cmd = new OleDbCommand("SELECT order_item.order_ID, order_user.firstname, order_user.lastname, order_user.billtype, order_user.purchase_date,order_item.barcode, order_item.product, order_item.price, order_item.qty, order_item.discount, order_item.total, order_item.cgst, order_item.sgst FROM order_item right JOIN order_user ON val(order_item.order_id) = order_user.ID where purchase_date between '" + from + "' and '" + to + "'", con);
- cmd.ExecuteNonQuery();
- DataTable dt = new DataTable();
- OleDbDataAdapter da = new OleDbDataAdapter(cmd);
- da.Fill(dsr.order);
- }
- else
- {
- OleDbCommand cmd1 = new OleDbCommand("SELECT order_item.order_ID, order_user.firstname, order_user.lastname, order_user.billtype, order_user.purchase_date,order_item.barcode, order_item.product, order_item.price, order_item.qty, order_item.discount, order_item.total, order_item.cgst, order_item.sgst FROM order_item INNER JOIN order_user ON val(order_item.order_id) = order_user.ID;", con);
- cmd1.ExecuteNonQuery();
- DataTable dt1 = new DataTable();
- OleDbDataAdapter da1 = new OleDbDataAdapter(cmd1);
- da1.Fill(dsr.order);
- }
- CrystalReportSales salesReport = new CrystalReportSales();
- salesReport.SetDataSource(dsr);
- salesReport.SetParameterValue("from", from);
- salesReport.SetParameterValue("to", to);
- salesReport.SetParameterValue("gtotal", gtotal);
- crystalReportViewer1.ReportSource = salesReport;
- }
- }
Vishal JadavPosted May 21, 2018, 8:21 AM