Reputation: 21
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
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
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