Saving Files as Binary?

[jfrost10]

Hey guys,

We want to store a variety of files in our sql server database as strait binary (in a BLOB format-ish). Any thoughts on how this is accomplished within the framework?

Thanks,

D

 

[MickTheBelgian]

If the files are on the hard-disk you can read it in as a giant byte-array and start from there.
Look in help for filestream and the different dataypes available in your specific database.

 

[younguser]

download 101 samples from microsoft. There is a sample of how to read and write image file.(binary)

 

[jfrost10]

Younguser, thanks for the tip about the 101 samples, I'll check it out.

Mick, thanks as well. unfortunately, we need to be able to do this all from within memory (there will be no hard-copy of the files on the disks)

Thanks guys,

D