Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  Export to excel

Author  Topic  reenz Starting Member 29 Posts Posted - 2006-05-08 : 01:07:34 I have a web form that allows user to enter in multiple account numbers. And each account number will be passed into a stored procedure to return a resultset which will be tied to say a datagrid. Currently, my web form is catered for 1 account number whereby 1 datagrid will displayed that account number's details and other information. There is a button which export this datagrid to excel. I am having a major headache now when user keys in multiple account numbers. what i want is each account number's details is being exported to an excel spreadsheet file or workbook at the user's drive. However, the normal export excel methods used used response.end or response.flush which will stop the flow. Hence i am unable to use a loop to call the export excel function for each account number, as it will stop after the first export. Any idea or recommendations? thanks