private void btnSubmit_Click(object sender, EventArgs e) { TreatmentInvoice ti = new TreatmentInvoice(); SqlConnection conn = new SqlConnection(); conn = DBConnection.getConnection(); string patientnic = txtdocinic.Text; conn.Open(); string sql = "select * from Treatments where PatientNICNo ='" + patientnic + "'"; DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); adapter.Fill(ds, "Treatments"); DataTable dt = ds.Tables["Treatments"]; ti.SetDataSource(ds.Tables["Treatments"]); crystalReportViewer1.ReportSource = ti; crystalReportViewer1.Refresh(); conn.Close(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TreatmentInvoice rpt = new TreatmentInvoice(); rpt.Site = this.Site; return(rpt); }
private void InvoiceRegistration_Load(object sender, EventArgs e) { TreatmentInvoice report = new TreatmentInvoice(); TreatmentDataSetTableAdapters.DataTable1TableAdapter ta = new DentalCare.TreatmentDataSetTableAdapters.DataTable1TableAdapter(); TreatmentDataSet.DataTable1DataTable table = ta.GetData(); report.SetDataSource(table.DefaultView); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }