Re: How can I open a file in WSS database by Joris
Joris
Tue Apr 11 03:12:56 CDT 2006
Just needed to read some files from it :)
Found it (ASP.NET):
(This reads the binary data from the database and shows it, it's a pdf file)
Try
myCommand.CommandTimeout = 500
cnnDatabase.Open()
Dim dreader As SqlDataReader = myCommand.ExecuteReader()
If (dreader.Read()) Then
Response.ContentType = "application/pdf"
Response.BinaryWrite(dreader("Content"))
End If
'dreader.Read()
'Dim test As Byte() = dreader("Content")
Catch ex As Exception
Me.Label1.Text = ex.ToString
Finally
cnnDatabase.Close()
End Try
Greetz
Joris
"Todd Klindt" <usenet@klindt.org> wrote in message
news:%23k4QS5LXGHA.1228@TK2MSFTNGP02.phx.gbl...
> All the documents from the Shared Documents library are in the Docs table
> of the content DB. Be careful, if you do any writing to those DBs outside
> of the WSS OM Microsoft will not support your installation. They don't
> seem to mind if you just read from them though, so you should be fine.
>
> tk
> "Joris De Groote" <joris.degroote@skynet.be> wrote in message
> news:OQVhRdJXGHA.1084@TK2MSFTNGP04.phx.gbl...
>> Hi
>>
>> How can I open a file that is located in the WSS database, but I don't
>> want to open it through WSS but trough an ASP.NET page? Is this possible?
>> How can I ask for this file or where is this document stored in the
>> database?
>>
>> Thanks
>> Joris
>>
>
>