Hide Gridview paging on export to excel asp.net

Question

User-1218295081 posted

Dears,

I want to hide gridview paging on export to excel asp.net without using AllowPaging = False

Thank you.

Answer 1

User1724605321 posted

Hi md_refay ,

If you want to enable gridview paging , but when exporting to excel with all page records(without paging) ,here is a demo :

http://www.aspsnippets.com/Articles/Export-GridView-all-pages-with-Paging-enabled-AllowPaging-to-Excel-in-ASPNet.aspx 

Best Regards,

Nan Yu

Answer 2

User-1218295081 posted

Dear

I don't want to use AllowPaging = False

Thank you

Answer 3

User-1902643333 posted

Dear

I don't want to use AllowPaging = False

Thank you

Then u can export directly through the DataTable instead of exporting a GridView. I mean you should combine strings together with data in the DataTable by foreach to loop its DataRow, DataColumn……,ect.