Downloading a .doc stored in SQL Server from an ASP.net page

[Jeppe Dige Jespersen]

I am building a page that takes a single parameter: documentId. I have
documents stored in a SQL Server 2005 database. Storing and retrieving these
from a WinForms application works fine. No problemo there.

But, when retrieving the docs from my asp.net page, the docs are somehow
corrupted, and I cannot open them using MS Word.

Documents are stored in the "data" field of my Documents table. The "data"
fields is of datatype Image. The documentId parameter is used to select the
right document from the table.

Any ideas? Anything, anyone? Any help appreciated....

/j.jespersen
***************

<%@ Page Language="VB" %>

<script runat="server">

Public Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim con As New
System.Data.Sql Client.SqlConne ction("server=m yServer;databas e=myDatabase;in tegrated
security=true")
Dim cmd As New System.Data.Sql Client.SqlComma nd("Select * From
Documents where id=" & Request.QuerySt ring("documentI d"), con)

con.Open()
Dim dr As System.Data.Sql Client.SqlDataR eader = cmd.ExecuteRead er

If dr.Read Then
Response.Clear( )
Response.AddHea der("Content-Type", "applicatio n/msword")
Response.AddHea der("Content-disposition", "attachment ;
filename=myword .docx")
Response.Binary Write(CType(dr( "data"), Byte()))
End If

con.Close()
con = Nothing

End Sub

</script>

***************

[Alexey Smirnov]

"Jeppe Dige Jespersen" <jd*@jdj.dkwrot e in message
news:uo******** ******@TK2MSFTN GP03.phx.gbl...

>I am building a page that takes a single parameter: documentId. I have
documents stored in a SQL Server 2005 database. Storing and retrieving
these from a WinForms application works fine. No problemo there.

But, when retrieving the docs from my asp.net page, the docs are somehow
corrupted, and I cannot open them using MS Word.

Documents are stored in the "data" field of my Documents table. The "data"
fields is of datatype Image. The documentId parameter is used to select
the right document from the table.

Any ideas? Anything, anyone? Any help appreciated....

/j.jespersen
***************

<%@ Page Language="VB" %>

<script runat="server">

Public Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim con As New
System.Data.Sql Client.SqlConne ction("server=m yServer;databas e=myDatabase;in tegrated
security=true")
Dim cmd As New System.Data.Sql Client.SqlComma nd("Select * From
Documents where id=" & Request.QuerySt ring("documentI d"), con)

con.Open()
Dim dr As System.Data.Sql Client.SqlDataR eader = cmd.ExecuteRead er

If dr.Read Then
Response.Clear( )
Response.AddHea der("Content-Type", "applicatio n/msword")
Response.AddHea der("Content-disposition", "attachment ;
filename=myword .docx")
Response.Binary Write(CType(dr( "data"), Byte()))
End If

con.Close()
con = Nothing

End Sub

</script>

***************

Maybe this helps

Response.Buffer = True

[Jeppe Dige Jespersen]

>

Maybe this helps

Response.Buffer = True

Doesn't solve the problem, but thanks for trying :-)

/j.jespersen

[Alexey Smirnov]

On Mar 26, 1:24 pm, "Jeppe Dige Jespersen" <[e-mail] te:

Maybe this helps

Response.Buffer = True

Doesn't solve the problem, but thanks for trying :-)

/j.jespersen

Try to save the response as a file to see how many bytes are there.

>From the first look your code is correct.

[Jeppe Dige Jespersen]

>

Try to save the response as a file to see how many bytes are there.

How would I do that? (i just dont know)

Could it be that the files that i am trying to save/retrieve are Word 2007
..docx files (that are really zip files)?
If I try it with a regular (Word 2003) document, it works fine. But not with
..docx files :-(
Any ideas?

/j.jespersen

[Alexey Smirnov]

On Mar 26, 1:46 pm, "Jeppe Dige Jespersen" <[e-mail] te:

Could it be that the files that i am trying to save/retrieve are Word 2007
.docx files (that are really zip files)?

Indeed!

Try to remove

Response.AddHea der("Content-Type", "applicatio n/msword")

-------------------------

Response.Clear( )
Response.AddHea der("Content-disposition", "attachment ;
filename=myword .docx")
Response.Binary Write(CType(dr( "data"), Byte()))

[Jeppe Dige Jespersen]

>
Response.AddHea der("Content-Type", "applicatio n/msword")

Same result. :-(

/j.jespersen

[Alexey Smirnov]

On Mar 26, 4:11 pm, "Jeppe Dige Jespersen" <[e-mail] te:

Response.AddHea der("Content-Type", "applicatio n/msword")

Same result. :-(

Apologies, I've found an article in MDSN and didn't look what the code
they've suggested ;-)

http://msdn.microsoft.com/msdnmag/is...s/default.aspx

On the source code page you will find the following

Response.Conten tEncoding = System.Text.Enc oding.UTF8
Response.Conten tType = "applicatio n/vnd.ms-word.document.1 2"

As you have no problem to open the file from WinForms. I think your
problem is in encoding, although maybe "vnd.ms-word.document.1 2" is
also important...

Please try

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

Here I've covered how to upload files into a SQL Server database and how to
successfully download them again to the client:
It works for Word docs and virtually any other kind of file too.
http://SteveOrr.net/articles/EasyUploads.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Jeppe Dige Jespersen" <jd*@jdj.dkwrot e in message
news:uo******** ******@TK2MSFTN GP03.phx.gbl...

>I am building a page that takes a single parameter: documentId. I have
documents stored in a SQL Server 2005 database. Storing and retrieving
these from a WinForms application works fine. No problemo there.

But, when retrieving the docs from my asp.net page, the docs are somehow
corrupted, and I cannot open them using MS Word.

Documents are stored in the "data" field of my Documents table. The "data"
fields is of datatype Image. The documentId parameter is used to select
the right document from the table.

Any ideas? Anything, anyone? Any help appreciated....

/j.jespersen
***************

<%@ Page Language="VB" %>

<script runat="server">

Public Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim con As New
System.Data.Sql Client.SqlConne ction("server=m yServer;databas e=myDatabase;in tegrated
security=true")
Dim cmd As New System.Data.Sql Client.SqlComma nd("Select * From
Documents where id=" & Request.QuerySt ring("documentI d"), con)

con.Open()
Dim dr As System.Data.Sql Client.SqlDataR eader = cmd.ExecuteRead er

If dr.Read Then
Response.Clear( )
Response.AddHea der("Content-Type", "applicatio n/msword")
Response.AddHea der("Content-disposition", "attachment ;
filename=myword .docx")
Response.Binary Write(CType(dr( "data"), Byte()))
End If

con.Close()
con = Nothing

End Sub

</script>

***************