ShiggityShaw
ShiggityShaw

Reputation: 21

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.

Upvotes: 1

Views: 472

Answers (2)

jasonk
jasonk

Reputation: 1570

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

Upvotes: 1

Giorgi
Giorgi

Reputation: 30873

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.

Upvotes: 1

Related Questions