Export From Gridview to excel

Question

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

john ginzo · Answer

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 Chand · Answer

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.