Automatic Download 2

[bigfoot]

Some background:
We have a website where the customers go to see their orders.
They want to be able to download data (the orders) from my SQL database in Excel, or Access, or Text format.
There should be no problem exporting from SQL Server. But that's not why I'm here.

ASP Question:
I have to create a file somewhere, and it needs to be unique to each user, Yes?. How would I create an auto download where the file gets pushed out to the user?

You know, like when yo go download somewhere and the screen comes up and you didn't click on any link, but your download screen comes up asking you to save or open.

This would happen when they clicked on a button that said "Download your orders in Excel Format".

Am I making any sense?

 

[SonJ]

in the page_load sub add these 2 lines

Response.AddHeader("content-disposition", "attachment;filename=FileName.xls;&quot
Response.ContentType = ("application/vnd.ms-excel&quot

then execute your query and on the front end, format the results into a table (possibly using a datagrid or a repeater).

hth
SonD

 

[bigfoot]

Thank you. I'll be able to look up the rest. I'll need one for Access, XML, and comma delimited.

 

[RachelK]

Sond,

I have used your code

Response.AddHeader("content-disposition", "attachment;filename=FileName.xls;&quot
Response.ContentType = ("application/vnd.ms-excel&quot

in a command button when I try to export the datagrid. If I have allow paging on it work and exports the 10 lines on the first page. If I take allow paging off when I click on the command button it will open excell but say unable to read file any idea's

 

[chix001]

RachelK,

Check out SonD's other post

http://www.tek-tips.com/viewthread.cfm?SQID=644738&SPID=855&newpid=855&page=1

for the answer to your question.

Thanks,
CHIX001