Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Eiríkur Egilsson
1510
Export *all data* in Grid - when using multiple paging ("prev"/"next")
posted

Hi there!

How can I export all the data from the grid, when it's using paging ?
That is I have e.g. 3 pages of data ( only 1 is visible at any time ... then I click "prev" / "next" to get all the results ... page by page )

If I export ( e.g. to PDF or Excel ) I get only the data which is visible in the grid at each time ( e.g. only page1, page2 or page3 ... not the whole data ) so the business is having to export x3 times and then copy/paste the results from 3 pages into one Excel file !?

I preferably don't want to cache the whole DataSource in Session/ViewState because it can be LOADS of data in the Grid ( e.g. 845+ pages )

Kind regards,
EE

  • 1510
    posted

    got no answers from your tech support on this asp.net forum to this question ... but I found out what I need to to:
    I need to turn of the paging mechanism, reload the data into the grid, databind it **again** and then I'm able to export the whole data. Just wanted users to know this if they read this question/post of mine.

    your asp.net forum-support isn't near the quality of the windows-forms support :-/

    rgd,
    EE