Home All Groups Group Topic Archive Search About

saving documents in sql2005 using vb.net

Author
31 Jul 2006 7:59 PM
Zrod
hi.
i need to be able to save documenets (files) in an sql binary field.
i don not know in advance teh typt of document,
Anyone can help ion writing the code required?
Thanks

Author
1 Aug 2006 9:09 PM
MyndPhlyp
"Zrod" <z***@aims-co.com> wrote in message
news:eDiIkvNtGHA.4748@TK2MSFTNGP03.phx.gbl...
> hi.
> i need to be able to save documenets (files) in an sql binary field.
> i don not know in advance teh typt of document,
> Anyone can help ion writing the code required?

Your VB.Net Help should give you some examples. Look in the Index for
ADO.NET and then the BLOBs subsection. It is stored and retrieved similar to
any other table column.

For Classic ADO you would use GetChunk and AppendChunk.