Store files in the database?

[Steve]

How do I store files in a database? I have done something similar before in
a none microsoft language in a previous lifetime, byt breaking it down into
chunks and storing it in a BLOB field. Is this the same in SQL?

I have an app written for windows in C# with SQL 2000 on the back. I have a
print engine which users XML documents as the print document template, and
was hoping I could store these in the database, rather than shipping actual
documents out with the app. The idea being I retrieve the docs at runtime
from the db, rebuild them on the client, then print them off.

Any ideas ?

Thanks

Ste

[Cor Ligthert [MVP]]

Steve,

Just see the samples from an image for that, it is even better if you first
Zip them.

Check our website and search for image. Although all our samples are made
for VB.Net

http://www.windowsformsdatagridhelp.com/default.aspx

I hope this helps,

Cor

[Steve]

I've managed to get the document into the db, I cant work out though how to
write it back out to disk. In your example you have a Bitmap object, is
there and equivalant object for a document? How do I specify where to write
the object to ?

"Cor Ligthert [MVP]" wrote:

Steve,

Just see the samples from an image for that, it is even better if you first
Zip them.

Check our website and search for image. Although all our samples are made
for VB.Net

http://www.windowsformsdatagridhelp.com/default.aspx

I hope this helps,

Cor

[Cor Ligthert [MVP]]

Steve,

It is the same, you read the file, store it in as a bitmap using the
memorystream and than you can get it again as a file as well using the
memorystream. The way you handles the data is of course the same as you
would handle the normal file. A textfile you would normaly handle as a
string by instance, however a doc would need interop.

I hope this helps,

Cor