Downloading file from database causes page to stop responding???

I have binary files stored in a SQL Server table that I want the user
to be able to download from an aspx webpage. The files are displayed
on the form as "LinkButtons". When the link is clicked the code in my
event handler writes out the contents of the file which prompts the
user for the download or open dialog box. The first time you click an
attachment it opens fine but any action on the page after that doesn't
seem to work, the page just stops responding. Trying to click other
attachments do not open and clicking Buttons stop responding. Below is
my EvenHandler... any idea what I'm doing wrong? Should I not be doing
this in an event handler?






1 void LinkButton_Download_Command(object sender, CommandEventArgs
e)
2
3 {
4
5 DBFile f =
DBFile_DAL.GetByID(Convert.ToInt32(e.CommandArgument));
6
7
8 Page.Response.AppendHeader("Content-Disposition",
"Attachment; Filename=" + f.FileName);
9
10 Page.Response.ContentType = "application/download";
11
12 Page.Response.BinaryWrite(f.FileData);
13
14 }
15
16

Re: Downloading file from database causes page to stop responding???

"~john" wrote in message
news:2622ad0f-c1e2-475e-aea6-70b39856b414@l32g2000hse.google groups.com...

10 Page.Response.ContentType = "application/download";
11 Page.Response.Flush();
12 Page.Response.BinaryWrite(f.FileData);
13 Page.Response.End();


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: Downloading file from database causes page to stop responding???

> 10 =A0 =A0Page.Response.ContentType =3D "application/download";
> 11 =A0 =A0Page.Response.Flush();
> 12 =A0 =A0Page.Response.BinaryWrite(f.FileData);
> 13 =A0 =A0Page.Response.End();


I just tried that and got this output in IE.






The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and
then click the Refresh button, or try again later.

------------------------------------------------------------ ----------------=
----

An invalid character was found in text content. Error processing
resource 'http://greenstapler/iso/ems/Pages/CarParForm.asp...

GIF89a

Re: Downloading file from database causes page to stop responding???

Also I'm doing this in an event handler of the same web page. Do I
need to redirect to another web page to handle the download?

John

Re: Downloading file from database causes page to stop responding?

From what you describe, it would be a lot cleaner and less error-prone to
have the download appear in a separate window that can then be closed,
allowing the user to continue operating in the original page.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com


"~john" wrote:

> Also I'm doing this in an event handler of the same web page. Do I
> need to redirect to another web page to handle the download?
>
> John
>
>

Re: Downloading file from database causes page to stop responding???

"~john" wrote in message
news:ca5c3003-4dfd-4dd9-acc7-0fd0e8fe3150@p69g2000hsa.google groups.com...

> Also I'm doing this in an event handler of the same web page. Do I
> need to redirect to another web page to handle the download?

That would certainly be my preferred way of doing it, yes...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: Downloading file from database causes page to stop responding???

Thanks everyone... Also, I should mention this code is inside a
SharePoint 2007 WebPart. When copying the same code over to a regular
ASP.net webpage it appears to work fine. I'm not sure why SharePoint
would treat it differently.

John