SortComparer for DataTable items source

[Ondrej Svoboda]

Hi,

I have SfDataGrid bound to DataTable with AutoGenerateColumns="True". I need to define custom sort comparer for string columns (to suport natural sorting).

Is there a way how to do it?

Thanks!

[Ondrej Svoboda]

I've found the solution in the other thread: https://www.syncfusion.com/forums/121745/filter-on-the-combobox-itemssource

Converting DataTable to dynamic objects does the trick.

[Farjana Parveen Ayubb]

Hi Ondrej, 

 

Thanks for the update. 

 

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you. 

 

Regards, 

Farjana Parveen A 

[Johnes]

Hello Ondrej

please can you explain how dynamic objects can to support natural sorting on Sfdatagrid?

I have the same question but still don't know how dynamic objects can help.

[Ondrej Svoboda]

Custom sort comparers are not allowed for DataTable source. So you need to first convert DataTable to dynamic objects to be able to use custom sort comparers.

Some examples can be found here: http://www.syncfusion.com/forums/121745/filter-on-the-combobox-itemssource?reply=lEJ2ue