GridControlSort

Sorting is directly supported in a GridDataBoundGrid based on the grids through the underlying datatable. For GridControl based grids, this sample will show you how to add header-click sorting to your grid. The header cell draws a sort icon to indicate that the column has been sorted in a particular direction.

Given below is a sample screen shot.

GridControlSort

• There is an inbuilt class, the GridSortColumnHeaderCellModel which, by passing an instance through the CellModels.Add function creates a CellType.

    		this.gridControl1.CellModels.Add("ColumnHeaderCell", new GridSortColumnHeaderCellModel(this.gridControl1.Model));
    		this.gridControl1[0, col].CellType = "ColumnHeaderCell";  

• The direction of the sort icon can be controlled by passing the Ascending or Descending options of the ListSortDirection enumerator through the tag property of the grid.

    		ListSortDirection dir = ListSortDirection.Ascending;
    		this.gridControl1[0, col].Tag = dir;  

• Sorting is done by the Data.SortByColumn function. There are 5 overloads for this function. It also enables comparison through the custom comparer.

    		this.gridControl1.Data.SortByColumn(col, dir, new FormulaComparer());  

• A custom comparer class which, derives the IComparer is used to compare the formula values and not the formulas.

• The FormulaTag.Text property has the formula result and it is used to compare two cells.