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

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



Best Regards,
Earl Francis

any file type

What database system?

SQL Server 2005

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?

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

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

With thanks
rajesh,
India

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.