Embedding Files in Database with VB.NET

miketayo · #1 (**permalink**) December 7th, 2006, 11:28 PM

Hi,

I am in need of some urgent help with my file transfer program

i need to embed my files in the database so that i can move my db and know that my files are ok.

i need the code to use in vb.net to be able to save the file in the db.

thanks

ef1196 · #2 (**permalink**) December 8th, 2006, 08:05 AM

What type of files are you wishing to save to the DB?

Best Regards,
Earl Francis

miketayo · #3 (**permalink**) December 8th, 2006, 10:00 AM

any file type

BrianWren · #4 (**permalink**) December 8th, 2006, 07:09 PM

What database system?

miketayo · #5 (**permalink**) December 11th, 2006, 09:41 AM

SQL Server 2005

BrianWren · #6 (**permalink**) December 15th, 2006, 02:46 PM

Oracle has a type BLOB (Binary Large OBject) which will accept the type of data you would find in a file; surely SQLServer does as well.

Open the file and read it into a column of that type. I would think that would do it.

What have you tried thus far, and what results have you met with?

miketayo · #7 (**permalink**) December 27th, 2006, 08:53 AM

The problem is not inserting it through the db but converting the file to bytes in vb so as to use the memorystream to get the bytes and them save it to the db.
example
Dim ms as memorystream
dim arr() as bytes = ms.GetBuffer

rajessnit@gmail.com · #8 (**permalink**) February 25th, 2008, 09:18 AM

U can use binary data type to store file in sql server2005

With thanks
rajesh,
India

BrianWren · #9 (**permalink**) February 25th, 2008, 01:16 PM

I don’t follow. Files are stored in bytes. It seems you would be able to just read the file in binary format, and be done with it. I suppose if you want an intermediate storage, you could create an array of bytes, and read it into that.

Plus Rajesh seems to be indicating that SQL actully has an intrinsic column type designed to hold a file.

Need to download code?

Navigation