Hi,
My Users need to see some data in Excel.
1. I need to show my RecordCount in Datagrid.
2. I need to export the datagrid to Excel. how do I do these 2 steps?
3. If I don't want to show the data to the user, what is the easiest way to have some data from Dataview or datatable or....Export to excel?
for example I like to have the output of this sql in the excel in ASP.net : Select Name,address from Customer and I like to have the number of record as well at the end of the report.
Thanks for any help

For the second point you could take a look at http://www.greggriffiths.org/webdev/both/excel/ which covers this.