I need to generate a file from binary information in sql........

Question

I am writing a windows desktop application in visual basic and I need it to connect to a SQL database, take a rows unique id, and using that number generate a file from the binary data that is stored in the SQL database and save it to a file directory.

The part that is hanging me up is the creating the file from the binary SQL data.

Any help would be appreciated. Thanks.

Answer 1

Here is an example which shows how to store/generate images from sql server database: How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET You can use it for any type of file.

Answer 2

VB6 or .net? You have both tags but the text says only visual basic.

Possible solution: http://www.vbdotnetheaven.com/UploadFile/mahesh/BLOBinAdoDotNet04232005065613AM/BLOBinAdoDotNet.aspx