This is how my source page looks likeEverthing works fine, i am able to export both the grids into a single excel.
but i had a question in this i have set page size as 100 as you can see so when i am exporting to excel only the 100 items are getting exported (which is right).
this is my code behind method for exporting
so if in this method i add in export settings as ignore paging i am getting an error saying the below message
Object reference not set to an instance of an object.
can any of you guys tell me how i can get over this speed bump