protected void LoadData() { DataTable dt = null; if (_refreshData || Session["dtUserCerts"] == null) { WTS_User u = new WTS_User(this.UserId); dt = u.CertificationList_Get(); HttpContext.Current.Session["dtUserCerts"] = dt; } else { dt = (DataTable)HttpContext.Current.Session["dtUserCerts"]; } if (dt != null) { this.DCC = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); int count = dt.Rows.Count; count = count > 0 ? count - 1 : count; //need to subtract the empty row spanRowCount.InnerText = count.ToString(); InitializeColumnData(ref dt); dt.AcceptChanges(); } grdCerts.DataSource = dt; grdCerts.DataBind(); }