Saving files in SQL 2005 using VB.net 2005

[manared]

I want to save files in SQL 2005 databases using VB.net 2005. How do I do this? What is the code to use?

Then, how do I retrieve the files?
Thanks much!

 

[TechGnome]

I think this link is still good.... it was written against FW 1.1... but should still work in 2.0.

http://support.microsoft.com/default.aspx?scid=kb;en-us;308042

-tg

 

[manared]

Thanks!! That helps. But, what if there are many people on the network and a file from one computer needs to be saved on the network. So what if the filename is from one computer and someone else needs to get to it to see what it is?

 

[TechGnome]

The file name has nothing to do with anything, other than being the file source location when loading it into the DB, and being the destination file location when extracting.

We use similar method here, letting the user browse for the sourcce file, stuff it into the DB. When we need to get it back out, it's extracted to a LOCAL folder on the user's hard drive.... so it doesn't matter where on the network it was originaly located... when the user does the action to extract it, it's saved to their machine.

-tg