Date: 03/27/08 (Web Development)    Keywords: html, database, asp, sql, web

I have taken over a website from another developer and am learning ASP.net and VB.net as I go. He had report functionality that did a query of the database, threw it in a gridview and then added a few lines of code that let it export from the gridview directly in Excel. The customer had me completely redesign the reports so that they required multiple queries of the database to get all the data and display it properly. I've put it into a basic HTML table. My questions are these:

1) Would it have been possible to manually put the data in a gridview, or is a gridview by definition bound to one sql query (I believe the answer is no, its not possible, but would just like to verify.
2) Is there any way to export info from an HTML table into an Excel spreadsheet? Or is it more a case of having to open a new Excel document and add in each field like I had to for the HTML table?

Any and all thoughts and suggestions are welcomed. Thanks in advance!

Source: http://community.livejournal.com/webdev/472128.html