Sort a String

[Patrick Gruhn]

Hello,

I have a TextColumn in my grid that contains data like this:

10
11
100
100A

I would like to sort this string like numbers (e.g. 10, 11,....), but I can't set simple the DataType of this Column because of the Characters.

Is there any way to sort like this?

Best regards,
Patrick

[Svett]

Hi Patrick Gruhn,

You can achieve that by enabling the custom sorting feature. You can do it by setting the CustomDataOperation property of the column to CustomDataOperation.Sorting. Then you can handle the CustomSorting event:

private void radGridView1_CustomSorting(object sender, GridViewCustomSortingEventArgs e)
{
    object value1 = e.CellValue1;
    object value2 = e.CellValue2;

    // If are equal: 0
    // If value1 is less than value2:  -1
    // if value1 is greater than value2: 1
    // e.SortResult =
}

In the event you can compare the values in the way that you want. You should set the SortResult property of GridViewCustomSortingEventArgs to accomplish the sorting.

Sincerely yours,
Svett
the Telerik team

[Nikolay]

Hi Patrick Gruhn,

You can achieve that by enabling the custom sorting feature. You can do it by setting the CustomDataOperation property of the column to CustomDataOperation.Sorting. Then you can handle the CustomSorting event:

private void radGridView1_CustomSorting(object sender, GridViewCustomSortingEventArgs e)
{
    object value1 = e.CellValue1;
    object value2 = e.CellValue2;

    // If are equal: 0
    // If value1 is less than value2:  -1
    // if value1 is greater than value2: 1
    // e.SortResult =
}

In the event you can compare the values in the way that you want. You should set the SortResult property of GridViewCustomSortingEventArgs to accomplish the sorting.

Sincerely yours,
Nikolay
the Telerik team

[Sangeetha]

I have following the version of telerik: 2010.1.10.504

I dont have the property for radgrid - CustomDataOperation property.

Please let me know how i can handle my own event for sorting.

[Richard Slade]

Hello,

If you don't have

Me.RadGridView1.Columns(0).CustomDataOperation = CustomDataOperation.Sorting

which is obsolete in the later versions of the controls then you should now use

Me.RadGridView1.MasterTemplate.EnableCustomSorting = True

hope that helps
Richard

[Sangeetha]

Hi

I found only -> Me.RadGridView1.MasterTemplate.EnableSorting = True

and not

Me.RadGridView1.MasterTemplate.EnableCustomSorting = True

[Richard Slade]

Hi,

It will either be one or the other. I suspect your older version still uses...

Me.RadGridView1.Columns(0).CustomDataOperation = CustomDataOperation.Sorting

I.e. The CustomDataOperation can be found at the column level, not at the grid level.
hope that helps
Richard

[Sangeetha]

Yup, it works. Thanks for the quick response.