$99 VS $1000+. UI Control for ASP.NET AJAX(contains chart and gridview).
GridView Sorting in ASP.NET AJAX
Home > How to > Grid Sorting
The Kettic GridView ASP.NET Ajax component provides a SortExpressions property for users to define the grid view data sorting function. This property is at the level of GridViewTemplate that is exposed in Kettic GridView C# class for MasterTemplate instance. The expressions for sorting allow users to create grid view data sorting property and grid data sorting direction. The expression is a collection so that users just need perform the delete or clear operation. The collection is able to sort grid data of the expression that has been newly added.

Sorting Modes

There are three sorting modes in grid: ascending, descending and no sort(default) mode. This sorting mode ico will appear in the each column header, it shows the current sort status of this web grid column.

1. Ascending: whole column value will sort by ascending order. Just click the column header, when the ico 'grid sort up function in asp.net ajax' appeared, this column will be ascending order.
2. Descending: whole column value will sort by descending order. Just click the column header, when the ico 'grid sort down function in asp.net ajax' appeared, this column will be descending order.
3. NoSort: whole column value will show in the original sort. Just click the column header, when there is no indicator appeared, this column will be no sort.
Please do a try to sort grid item in this page.

Sorting Expressions

The Kettic asp.net GridView component is able to create custom sorting of grid data. This flexible sorting allows users to sort rows data that is bound to GridView according to custom logic. To create custom sorting to grid data, we need enable the EnableSorting property. When enabling the sorting property, the GridView will sort data at all levels. You can set it to True in the design property windows or using the C# code in the programming.
Kettic web grid view also supply column sorting function. While soring a single column named "Date", then the other columns will dynamically change the cell data content to match the Date column order. If you want to sort a column value, you need to define the SortExpression property. In this property, you can change two options:
  • FieldName: the data field to sort by. This should be the name of a single field from data source or column header.
  • SortOrder: the sort mode. It can be Ascending or Descending.
ASPX sample code:

<kettic:GridSortExpression FieldName="CompanyName" SortOrder="Ascending" />
C# example code:

GridSortExpression expression = new GridSortExpression();
expression.FieldName = "CompanyName";
expression.SortOrder = GridSortOrder.Descending;

Changing background color of Sorted columns

To make a clear performance of the sorted columns, you can customize a different background color for it. So that readers can know the grid data content is ordering by which column in the web grid view. Set SortedBackColor to another color.

sort grid view single column in asp.net ajax

Multi-column Sorting

In some case, one column sorting may not display the data trend and changing clearly. So Kettic asp.net Grid view control allows users to make multiple columns sorting at same time. Set AllowMultiColumnSorting property to True, and the other settings is just as the same as the single column sorting.

Below screen shot is an example, with Contact Name ascending and Company Name descending. It means all the data is sorted by Contact Name in asecnding order, and exclude the Contact Name column, the left columns will show as descending order by Company Name. And you can try it yourself to sort multiple columns in web gridview on this free online demo.

sort grid multiple columns in asp.net ajax