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