private void BindGrid()
{
DataSet ds = new DataSet();
PaymentReportBo obj = new PaymentReportBo();
ds = obj.PaymentReportgrid(CompanyID, FromDate, Todate, FromVisitDate, ToVisitdate, Speciality, provider, BillNo);
grdPaymentReport.DataSource = ds;
grdPaymentReport.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
FromDate = txtFromBillDate.Text;
Todate = txtToBillDate.Text;
FromVisitDate = txtFromVisitDate.Text;
ToVisitdate = txtToVisitDate.Text;
Speciality = extddlSpeciality.Text;
provider = extddlOffice.Text;
BillNo = txtBillNo.Text;
DataSet ds1 = new DataSet();
PaymentReportBo obj = new PaymentReportBo();
ds1 = obj.PaymentReportgrid(CompanyID, FromDate, Todate, FromVisitDate, ToVisitdate, Speciality, provider, BillNo);
grdPaymentReport.DataSource = ds1;
grdPaymentReport.DataBind();
}