private void loadGridData() { DataTable dt; if (_refreshData || Session["dtMD_AOR_Type"] == null) { dt = MasterData.AOR_TypeList_Get(includeArchive: true); HttpContext.Current.Session["dtMD_AOR_Type"] = dt; } else { dt = (DataTable)HttpContext.Current.Session["dtMD_AOR_Type"]; } int count = 0; if (dt != null) { this.DCC = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); InitializeColumnData(ref dt); dt.AcceptChanges(); count = dt.Rows.Count; count = count > 0 ? count - 1 : count; //need to subtract the empty row } spanRowCount.InnerText = count.ToString(); if (_export && dt != null && CanView) { exportExcel(dt); } grdMD.DataSource = dt; grdMD.DataBind(); }