protected void LoadItems() { if (!HasEditPermission) { gvCatagoriesYad2.Columns[gvCatagoriesYad2.Columns.Count - 1].Visible = false; } Query qry = new Query(core.DAL.CategoryYad2.TableSchema); qry.OrderBy(core.DAL.CategoryYad2.Columns.CategoryYad2Name, dg.Sql.SortDirection.ASC); CategoryYad2Collection items = CategoryYad2Collection.FetchByQuery(qry); if (items == null || items.Count == 0) { phHasNoItems.Visible = true; //if no records, create collection with dummy record for gv data source only so that footer row will still be displayed, but will not be saved in cache items = new CategoryYad2Collection(); items.Add(new CategoryYad2()); lblTotal.Text = "0"; } else { phHasNoItems.Visible = false; lblTotal.Text = items.Count.ToString(); } gvCatagoriesYad2.DataSource = items; gvCatagoriesYad2.DataBind(); //if first row is just a dummy - hide it if (phHasNoItems.Visible) { gvCatagoriesYad2.Rows[0].Visible = false; } }