protected void Page_Load(object sender, EventArgs e) { btnRevert.Attributes.Add("onclick", "return ChekOne();"); lblMsg.Text = ""; if (!IsPostBack) {//bind office name to ddlOffice DataSet dsOfficeName = new DataSet(); string szCmpId = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString(); Bill_Sys_ReportBO objReport = new Bill_Sys_ReportBO(); dsOfficeName = objReport.GetOfficeName(szCmpId); ddlOffice.DataSource = dsOfficeName.Tables[0]; ddlOffice.DataTextField = "SZ_OFFICE"; ddlOffice.DataValueField = "SZ_OFFICE_ID"; ddlOffice.DataBind(); ddlOffice.Items.Insert(0, "--select--"); //bind gride DataSet dsOfficeName1 = new DataSet(); dsOfficeName1 = objReport.GetReceived_Report(szCmpId, "", "", "", "--select--"); #region " default viwe of grid sor by ascending order of date" DataView dv1; dv1 = dsOfficeName1.Tables[0].DefaultView; dv1.Sort = "DATE_OF_REFERRAL_PROC,PATIENT_NAME ASC"; grdReceivedeport.DataSource = dv1; grdExel.DataSource = dv1; Session["OfficeData"] = dsOfficeName1; grdReceivedeport.DataBind(); grdExel.DataBind(); #endregion if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1")) { grdReceivedeport.Columns[2].Visible = false; grdExel.Columns[2].Visible = false; } } }