public void BindGrid() { Bill_Sys_ReportBO objReport = new Bill_Sys_ReportBO(); DataSet dsReport = new DataSet(); if (extddlSpeciality.Text.Equals("NA")) { dsReport = objReport.GetPOM_Report(txtFromBillDate.Text, txtToBillDate.Text, txtFromServiceDate.Text, txtToServiceDate.Text, txtFromPrintedDate.Text, txtToPrintedDate.Text, txtFromRecDate.Text, txtToRecDate.Text, txtBillNo.Text, "NA", txtPatientName.Text, txtCompanyID.Text, txtBillNo.Text, txtPatientName.Text); } else { dsReport = objReport.GetPOM_Report(txtFromBillDate.Text, txtToBillDate.Text, txtFromServiceDate.Text, txtToServiceDate.Text, txtFromPrintedDate.Text, txtToPrintedDate.Text, txtFromRecDate.Text, txtToRecDate.Text, txtBillNo.Text, extddlSpeciality.Text, txtPatientName.Text, txtCompanyID.Text, txtBillNo.Text, txtPatientName.Text); } Session["POMReport"] = dsReport; grdPomReport.DataSource = dsReport.Tables[0]; // grdExel.DataSource = dsReport.Tables[0]; // grdExel.DataBind(); grdPomReport.DataBind(); }