Export all records to excel when I'm using RadDataPager for paging

[Pankaj]

Hi,
 
How can I export all the records to excel, when I'm using RadDataPager for paging.

Currentl when I export it export only the records which are currently displayed in grid.

Thanks,
Pankaj

[Thomas LEBRUN]

I have the exact problem: i'm exporting a RadGridView to Csv (bind to an IQueryable) and the export only displays the rows shown in first page.

How can i get all the items to be exported ?

Thanks !

[Dimitrina]

Hi Thomas,

If I have understood you right, basically what you should do is:

1. Save the PageSize and the PageIndex of the dataPager.
2. Set the PageSize of the dataPager to 0. 
3. Then export the data ((IEnumerable) dataPager.PagedSource ). 
4. Set the PageSize and the PageIndex back.

I hope that this is what you need. 

All the best,
Didie
the Telerik team