I need to generate a file from binary information in sql

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.

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.

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