I have a Grid with paging enabled. I am creating an export button inside the footer to exports Data from grid based on the current Grid data. Let's say someone filtered the Grid and we now have like 30 rows that spans over 4 pages. The grid has an ID as a DataKeyName.
What I want is to get all the IDs, not only of the first page but from all the grid and pass them to a Stored Procedure to get me shaped data I want for my export, bind it to a special Grid and export the data to Excel.
How can I be able to get all the IDs from the Grid and not just the ones from the current page.