Loading

Export From Gridview to excel

arul

Hi,

By defult i can able to export data from Gridview to Excel.it contains only current page gird.But i have several serach condition.based on this qurey i have to populate the grid wiht paging.

How can i generate the excel based on this qurey.ie Not only Current pange grid.i need to come all the paging data to Excel.is it possible ? please let me know..

- Arul

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

john ginzo19y ago
This is the way I normall do it. It has worked very well in the past:

http://authors.aspalliance.com/olson/methods/DataTable2ExcelString.aspx

John Ginzo
GinzoTech Solutions
http://www.GinzoTech.com
Mahesh Chand19y ago
See Office Interop or search this site for "Export Excel". There are many articles in this section on how to export a GridView to Excel. Export will export all data no matter if you have paging or not.