Mixing default and custom sorting in multisort scenario

RELATED TO:

Article information

Article relates to

 Q3 2012 SP1  

Created by

 Stefan Stefanov  

Last modified

 25 Dec 2012

Last modified by

 Stefan Stefanov

This example shows how to use both the default and custom sorting to sort your grid. In the below grid all columns prior Column2 are sorted with the default sort mechanism, while for Column2 itself, we will use custom sorting.



To achieve this, all you need to do is to set the EnableCustomSorting property of RadGridView to true and implement the desired sorting logic in the CustomSorting event handler, while keeping the default sorting for the rest of the cases:
C#
void radGridView1_CustomSorting(object sender, Telerik.WinControls.UI.GridViewCustomSortingEventArgs e)
{
    //sort all descriptors before 'column2' are using the default comparer
    SortDescriptorCollection descriptors = e.Template.SortDescriptors;
    int index = descriptors.IndexOf("Column2");
    if (index > 0)
    {
        SortDescriptorCollection context = new SortDescriptorCollection();
        for (int i = 0; i < index; i++)
        {
            context.Add(descriptors[i]);
        }
 
        e.SortResult = GridViewRowInfoComparer.CompareRows(e.Row1, e.Row2, context);
    }
 
    if (e.SortResult == 0 && index >= 0)
    {
        decimal value1 = (decimal)e.Row1.Cells["Column2"].Value;
        decimal value2 = (decimal)e.Row2.Cells["Column2"].Value;
        e.SortResult = decimal.Compare(value1, value2);
        if (e.SortResult != 0)
        {
            if (descriptors[index].Direction == System.ComponentModel.ListSortDirection.Descending)
            {
                e.SortResult *= -1;
            }
 
            return;
        }
    }
 
    //default sorting
    e.Handled = false;
}

VB
Private Sub radGridView1_CustomSorting(sender As Object, e As Telerik.WinControls.UI.GridViewCustomSortingEventArgs)
    'sort all descriptors before 'column2' are using the default comparer
    Dim descriptors As SortDescriptorCollection = e.Template.SortDescriptors
    Dim index As Integer = descriptors.IndexOf("Column2")
    If index > 0 Then
        Dim context As New SortDescriptorCollection()
        For i As Integer = 0 To index - 1
            context.Add(descriptors(i))
        Next
 
        e.SortResult = GridViewRowInfoComparer.CompareRows(e.Row1, e.Row2, context)
    End If
 
    If e.SortResult = 0 AndAlso index >= 0 Then
        Dim value1 As Decimal = CDec(e.Row1.Cells("Column2").Value)
        Dim value2 As Decimal = CDec(e.Row2.Cells("Column2").Value)
        e.SortResult = Decimal.Compare(value1, value2)
        If e.SortResult <> 0 Then
            If descriptors(index).Direction = System.ComponentModel.ListSortDirection.Descending Then
                e.SortResult *= -1
            End If
 
            Return
        End If
    End If
 
    'default sorting
    e.Handled = False
End Sub


More Resources

  • Forums

    Find answers to thousands of questions or reach out to our active community

  • Videos

    Over 100 videos on Telerik TV covering tips and tricks and new features in the controls

  • Demos

    Download 250+ C#/ VB.NET demos in a runnable Visual Studio project

  • Feedback Portal

    Vote and follow the features you want to see added to Telerik UI for WinForms

  • Documentation

    Detailed help articles and API references for all Telerik WinForms controls

  • Knowledge Base

    Tutorials and working examples on how to achieve common scenarios

  • Code Library

    Sample projects submitted by Progress staff and community members

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends

  • Release History

    Up-to-date release notes for all new features and improvements.