private void report_Click(object sender, EventArgs e) { printSaleForm printForm = new printSaleForm(); medicalStoreDataSet6 dataSet = new medicalStoreDataSet6(); dataSet.EnforceConstraints = false; companyNameReport report = new companyNameReport(); try { DataTable dt = new DataTable(); foreach (DataGridViewRow row in this.dataGridView1.Rows) { DataRow dr = dt.NewRow(); if (row.DataBoundItem != null) { dr = (DataRow)((DataRowView)row.DataBoundItem).Row; dataSet.companyName.ImportRow(dr); } } report.SetDataSource(dataSet); printForm.crystalReportViewer1.ReportSource = report; printForm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void report_Click(object sender, EventArgs e) { printSaleForm printForm = new printSaleForm(); stockDataSet dataSet = new stockDataSet(); dataSet.EnforceConstraints = false; viewExpireStockReport report = new viewExpireStockReport(); try { adapter1.Fill(dataSet.addStock); adapter2.Fill(dataSet.medicine); report.SetDataSource(dataSet); printForm.crystalReportViewer1.ReportSource = report; printForm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void print_Click(object sender, EventArgs e) { printSaleForm printForm = new printSaleForm(); invoideStoreDataSet dataSet = new invoideStoreDataSet(); CrystalReport2 report = new CrystalReport2(); try { String conString = ConfigurationManager.ConnectionStrings["medical_Store.Properties.Settings.medicalStoreConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(conString); con.Open(); String sql = "SELECT cashMemoNo,CustomerName,gross,disc,net FROM masterSale WHERE cashMemoNo='" + cashMemoNo.Text + "'"; SqlDataAdapter adapter = new SqlDataAdapter(sql, con); //DataTable table = new DataTable(); adapter.Fill(dataSet.masterSale); String sql2 = "SELECT medicineName,price,qty FROM childSale WHERE cashMemoNo='" + cashMemoNo.Text + "'"; SqlDataAdapter adapter2 = new SqlDataAdapter(sql2, con); //DataTable table = new DataTable(); adapter2.Fill(dataSet.childSale); report.SetDataSource(dataSet); dataSet.EnforceConstraints = false; printForm.crystalReportViewer1.ReportSource = report; printForm.Show(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }