Re: Opening MS WORD document from database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Simon,

make sure to delete everything except the page directive from your .aspx
page. That should do the trick!

Regards

Daniel


"Simon" <sbee@xxxxxxxxxxx> schrieb im Newsbeitrag
news:%23YxeiIY4FHA.700@xxxxxxxxxxxxxxxxxxxxxxx
>I tried putting it into a response.outputstream, but still not getting the
>actual file. Now, it displays the source of the web page instead. What am
>I doing wrong?
>
> ----[VB.net code]-----
> Dim db As New MD_Runs.Database(strDBConn)
> Dim dt As DataTable
> Dim sqlParams() As SqlParameter = { _
> New SqlParameter("@rid", rid)}
>
> dt = db.FillDataTable("usp_files_s_one", sqlParams)
>
> Dim fileData() As Byte = CType(dt.Rows(0)("FileData"), Byte())
>
> Response.Clear()
> Response.ClearHeaders()
> Response.ClearContent()
> Response.ContentType = "Application/msword"
> Response.OutputStream.Write(fileData, 0, fileData.Length)
> Response.OutputStream.Flush()
> Response.OutputStream.Close()
> ----------------------
>
>
>> "Jason Chu" <JasonChu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BA02D945-1DF4-4EA0-B940-0BD2E9F4CB17@xxxxxxxxxxxxxxxx
>>> I'm a C# programmer...so bare with it.
>>> you would need to put that byte[] into the Response.OutputStream.
>>> so..
>>> Response.OutputStream.Write(byte[],0,the length);
>>>
>>> along with the Response.ContentType set correctly, the browser will be
>>> able
>>> to handle it as a word file.
>>>
>>> Response.OutputStream will essentially turn your aspx file into a doc
>>> file...so the wordopener.aspx when you browse it...it'll be treated as a
>>> doc
>>> file...so nothing in the html tags would matter, as you won't see them.
>>>
>>> and when you're finished...end with Response.End
>>>
>>>
>>> "Simon" wrote:
>>>
>>>> I'm simplying trying to download and and open word documents that are
>>>> stored
>>>> in the database. I figured out how to uploaded the documents as Byte,
>>>> but I
>>>> can't figure out how to get them back out properly. The following code
>>>> is
>>>> what I've tried (vb.NET)... It goes as far as asking me to Save/Open
>>>> the
>>>> file, but when I do, the contents of the documents is the webage that
>>>> the
>>>> download link was on! I'm fairly new to programming/web development,
>>>> so
>>>> i'm
>>>> not totally sure what i'm doing. I hope i've included enough
>>>> information.
>>>>
>>>> Thanks in advance!
>>>>
>>>> Simon
>>>>
>>>> --- VB.NET code ---
>>>>
>>>> Public Sub DownloadFile(ByVal File_Id As Integer)
>>>> Dim dr As SqlDataReader
>>>> Try
>>>>
>>>> Me.OpenConnection(ConfigurationSettings.AppSettings("MD_Runs_Connection_String"))
>>>>
>>>> Dim sqlCmd As New SqlCommand("usp_files_s_by_file_id",
>>>> sqlConn)
>>>> sqlCmd.CommandType = CommandType.StoredProcedure
>>>> sqlCmd.Parameters.Add(New SqlParameter("@file_id",
>>>> File_Id))
>>>>
>>>> dr = sqlCmd.ExecuteReader()
>>>>
>>>> Do While dr.Read
>>>> Dim file() As Byte = CType(dr.Item("fileData"), Byte())
>>>> memStream.Write(file, 0, file.Length)
>>>> Loop
>>>>
>>>> memStream.Flush()
>>>> ContentType = dr.Item("Application/octet-stream")
>>>>
>>>> Catch
>>>> Throw
>>>> Finally
>>>> dr.Close()
>>>> Me.CloseConnection()
>>>> End Try
>>>> End Sub
>>>>
>>>>
>>>>
>>
>>
>
>


.

Relevant Pages