this is not only exports the data in gridview but it exports the entire page to excel.
You can use the SqlServer Reporting services to generate the excel. But i am not familiar with it.
the other old way is to use the Excel.Application in the WebServer. Which has its own difficulties in deployment and runtime But for your requirement it may fit. I have a
VB sample (windows forms application in VB6) . you can understand how you can use the Excel.Application, workbook, and worksheet to export data.
http://www.vbknowledgebase.com/WebAp...Excel-and-Save
Pon Saravanan
http://www.vbknowledgebase.com