Is it possible to define own comparer for columns in DataGrid

[Pavel Krebs]

Hello,

I have a RadDatagrid with more columns and I would like to use sorting functionality by clicking on column headers as it is implemented. Is it possible for some text columns to define own comparer. I need to compare strings "naturally" like: "Ring 1", "Ring 2", Ring 10", "Ring 11",...

Thank you,

 

Pavel

[Martin Ivanov]

Hello Pavel,

To achieve your requirement, you can implement a custom DataGrid column and override its CreateSortDescriptor method. This will allow you to set the Comparer property of the created SortDescriptorBase object.

 public class CustomDataGridTextColumn  : DataGridTextColumn
 {
     protected override SortDescriptorBase CreateSortDescriptor()
     {
         var descriptor = base.CreateSortDescriptor();
         descriptor.Comparer = new NaturalStringComparer();
         return descriptor;
     }
 }

 public class NaturalStringComparer : IComparer
 {
     [DllImport("shlwapi.dll", CharSet = CharSet.Unicode)]
     public static extern int StrCmpLogicalW(string psz1, string psz2);

     public int Compare(object? a, object? b)
     {
         return StrCmpLogicalW((string)a, (string)b);
     }
 }

I also attached a sample project showing this idea. I hope it helps.

Regards,
Martin Ivanov
Progress Telerik