September 28, 2005 at 9:01 am
I have an application, which stores Photographs in a SQL Database, I created these using a filestream method. Now I want to retrieve them and display them in a VB.Net App. Can anyone show me, point me to a site, that I might accomplish this. I was told and found several sites which use memorystream for this, but this app uses a SQLAdapter and a Store procedure to retreive the data, my main problem is using the image column and a record set as a result set(unable to process the field in design mode).
Thanks
September 28, 2005 at 10:19 pm
Try the link below for sample code from Microsoft but you need to know Memory stream because you can use it to convert the image to bytes and if you set some properties to readonly you can keep the file in memory for a long time. Hope this helps.
http://msdn.microsoft.com/smartclient/codesamples/fotovision/default.aspx
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
September 29, 2005 at 9:28 am
To add to Peddie's reply, if you use memorystream (recommended), you will also need to use an offset (78?) when retrieving the data to compensate for the header info in the database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply