private void btnSearchPatient_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtInvoiceNo.Text))
{
MessageBox.Show("The invoice number should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
CrystalReportGenerateInvoice cr = new CrystalReportGenerateInvoice();
SqlConnection conn = new SqlConnection();
conn = DbConnection.getConnection();
string pino = txtInvoiceNo.Text;
conn.Open();
string sql = "select * from generateinvoice where invoiceno='" + pino + "'";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(ds, "generateinvoice");
DataTable dt = ds.Tables["generateinvoice"];
cr.SetDataSource(ds.Tables["generateinvoice"]);
crystalReportViewer4.ReportSource = cr;
crystalReportViewer4.Refresh();
conn.Close();
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportGenerateInvoice rpt = new CrystalReportGenerateInvoice();
rpt.Site = this.Site;
return(rpt);
}