How to export data from SQL server database to Excel 2007 in ASP.NET?
<p>I am developing an application where I am required to provide the functionality of exporting my SQL database to Excel 2007 format using ASP.NET.</p>

<p>I have done it by first binding the grid and then on a click of the button the data is exported to Excel. But when the data is huge, it takes time to bind the grid and thus when I click the button the connection is lost.</p>
