Retrieve sorted and filtered datas

[theaidan]

Hi,

How can i retrieve data from the radgrid in a datatable-like object ?

like export to excel, keeping order and filter.
The final goal : i would like get all datas from the radgrid and set the datasource of a RadChart with it.

MasterTableView.DataSource is the original datasource (with no filter or sort), and iterate the items, only iterate the current page (RadGrid do not cache data, only keep current page...)

my dream is something like that :
myRadChart.DataSource = myRadGrid.MasterTableView.SortedAndFilteredDataSource;

any help will be appreciated :)

[Shinu]

Hi,

Please refer the following forum link which explains the similar scenario .
DataGrid to DataTable

Regards
Shinu.

[theaidan]

Hi Shinu,

thanks for your quick answer.
I forgot something juste essential in my original post, sorry... my RadGrid has pagination activated.
So the "foreach" statement seems iterate only into currently displayed items. :(
I search always how to iterate all filtered and sorted data like an excel export with "ignore Paging".
RadFilter + Radgrid is really awesome... just missing a method to retreive simply data like an export to ICollection for example :)

Regards,
theaidan.

[theaidan]

no body has ideas ?

[Pavlina]

Hi Theaidan,

The RadGrid control keeps only the current page of data when paging is enabled. It never requests or processes any other data than the current page. You have access to whatever data RadGrid is bound only. This is why, with paging, you cannot get data in other pages.

If you need to use the data in all pages, you could temporarily disable paging(set AllowPaging="false"), iterate over all your data items and then re-enable paging again.

Kind regards,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[theaidan]

Hi Pavlin,
thanks for your answer.
i will work on this way.

i will try do write an helper to work with radchart+radgrid+radfilter.

the final goal is for me : to display filtered grid and chart likes in google analitycs.The same datasource, the same filter, the same order... and no paging for graph :)

anyway, telerik components are the best I ever used for asp.net :)