protected void Sort(string sortExpression, params string[] sortExpr) { DataTable dataTable = Session["siteinfo_data"] as DataTable; if (dataTable != null) { if (Session["siteinfo_sortexpression"] == null) { Session["siteinfo_sortexpression"] = ""; } DataView dataView = new DataView(dataTable); string[] sortData = Session["siteinfo_sortexpression"].ToString().Trim().Split(' '); string newSortExpr = (sortExpr.Length == 0) ? (sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" : sortExpr[0]; dataView.Sort = sortExpression + " " + newSortExpr; Session["siteinfo_sortexpression"] = sortExpression + " " + newSortExpr; GrdSite.DataSource = dataView; GrdSite.DataBind(); } }
protected void FillGrid() { DataTable dt = SiteDB.GetDataTable(); if (dt.Rows.Count > 0) { if (IsPostBack && Session["siteinfo_sortexpression"] != null && Session["siteinfo_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["siteinfo_sortexpression"].ToString(); GrdSite.DataSource = dataView; } else { GrdSite.DataSource = dt; } Session["siteinfo_data"] = dt; try { GrdSite.DataBind(); } catch (Exception ex) { HideTableAndSetErrorMessage("", ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdSite.DataSource = dt; GrdSite.DataBind(); int TotalColumns = GrdSite.Rows[0].Cells.Count; GrdSite.Rows[0].Cells.Clear(); GrdSite.Rows[0].Cells.Add(new TableCell()); GrdSite.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdSite.Rows[0].Cells[0].Text = "No Record Found"; } GrdSite.FooterRow.Visible = !hideFotter; btnAddSite.Visible = br_before_add_site_btn_1.Visible = br_before_add_site_btn_2.Visible = !hideFotter; }