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();
}
