private void LoadReceipt(string No) { reportViewer1.LocalReport.DataSources.Clear(); Orders v = new Orders(); Customer c = new Customer(); Company y = new Company(); v = Orders.SelectNo(No); y = Company.Select(); /**Company Customer***/ Microsoft.Reporting.WinForms.ReportParameter rp = new Microsoft.Reporting.WinForms.ReportParameter("image", Helper.CompanyImage); this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { rp }); Coverage er = new Coverage(); //.Select(ItemID); er = Coverage.SelectType(v.CustomerID, "Primary"); Microsoft.Reporting.WinForms.ReportParameter rps = new Microsoft.Reporting.WinForms.ReportParameter("medicaid", er.No); this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { rps }); MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM delivery WHERE no='" + No + "'", MySQL.Conn); DataSet ds = new DataSet(); da.Fill(ds); MySql.Data.MySqlClient.MySqlDataAdapter da3 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM customer WHERE id='" + v.CustomerID + "'", MySQL.Conn); DataSet ds3 = new DataSet(); da3.Fill(ds3); MySql.Data.MySqlClient.MySqlDataAdapter da2 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT product.name AS itemID ,product.code AS self,product.description AS tax,casetransaction.cost,casetransaction.date as date,casetransaction.no as no,casetransaction.total as total,casetransaction.qty as qty,casetransaction.cost,casetransaction.created,casetransaction.sync,casetransaction.height,casetransaction.limits,casetransaction.weight,casetransaction.setting,casetransaction.instruction,casetransaction.period FROM casetransaction LEFT join product ON casetransaction.itemID = product.id WHERE casetransaction.no='" + No + "'", MySQL.Conn); DataSet ds2 = new DataSet(); da2.Fill(ds2); MySql.Data.MySqlClient.MySqlDataAdapter da4 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM practitioner WHERE id='" + v.PractitionerID + "'", MySQL.Conn); DataSet ds4 = new DataSet(); da4.Fill(ds4); ReportDataSource datasource = new ReportDataSource("DataSet1", ds.Tables[0]); ReportDataSource datasource2 = new ReportDataSource("DataSet2", ds2.Tables[0]); ReportDataSource datasource3 = new ReportDataSource("DataSet3", ds3.Tables[0]); ReportDataSource datasource4 = new ReportDataSource("DataSet4", ds4.Tables[0]); reportViewer1.LocalReport.DataSources.Add(datasource); reportViewer1.LocalReport.DataSources.Add(datasource2); reportViewer1.LocalReport.DataSources.Add(datasource3); reportViewer1.LocalReport.DataSources.Add(datasource4); reportViewer1.RefreshReport(); }