Sorting RadGrid with ObjectDataSource and List<Obejct>

[Christian]

Hello Telerik-team

I'm trying to use the RadGrid with an ObjectDataSource which delivers the Data in a List<Object>.

We can see the data in the RadGrid and paging is working fine.

But we can't sort the data. We get the error.

Die Datenquelle "odsdata" unterstützt das Sortieren von IEnumerable-Daten nicht. Die automatische Sortierung wird nur für DataView, DataTable und DataSet unterstützt.
or translated in english:

The datasource "odsdata" does not support the Sorting of IEnumerable-Data. The automatic sorting is only supported for DataView ...

In our software architectur we have to work with list<object> and the ObjectDataSource.

I tried to use the RadGrid OnSortCommand-Event, but I can't bind the sortet list<object> because I use the DataSourceID of the ObjectDataSource and can#t rebind the Data.

Are there any idea to solve the problem?

Christian

[Rosen]

Hi Christian,

Actually the error you have described is not related to RadGrid, but it is thrown by the ObjectDataSource as it does not support sorting on IEnumerable. However you can workaround this behavior be setting RadGrid MasterTableView's OverrideDataSourceControlSorting property to true.

Regards,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Christian]

Thanks!

Christian

[rajesh]

hi telerik team

i am also using object datasource and i tried with OverrideDataSourceControlSorting property to true.
But it showing an error.please help me to sort the grid

[Nikolay Rusev]

Hello Rajesh,

Please provide more details on your case.

All the best,
Nikolay
the Telerik team

[Matthias Heinrich]

Workaround works like charm! THX!

[TechSavvySam]

Thanks.  worked for me too :)

[Nathan]

This - this right here. Just saved me HOURS of work on a Sunday afternoon. <3 your work telerik bros.