Display DB Image

[C CORDON]

I have an image stored in a SQL DB how can I display it in a control on a
Windows Form?

TIA!

 

[Tom Shelton]

I have an image stored in a SQL DB how can I display it in a control on a
Windows Form?

TIA!

Well, I'm not too much of a db expert... But, what you are probably
ending up with is a feild in a dataset that amounts to a byte array -
assuming you are storing the actual image in the database. Once you
have the byte array, displaying that image in a PictureBox is actually
not that difficult... Actually, any setting any controls image
property...

You simply wrap the byte array in a System.IO.MemoryStream object and
call the Image.FromStream method. Here is some sample untested code...

Dim memStream As New MemoryStream (theByteArray)
PictureBox1.Image = Image.FromStream (memStream)

' you probably want to close the stream here...
memStream.Close ()

Anyway, HTH

 

[Mike McIntyre [MVP]]

This link should help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;326502


--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

 

[C CORDON]

I think I forgot to mention I am working on ASP.NET.

I got to the poit of loading the Byte() from the Image field in the table
but don´t know ehre to go from there.

Thanks anyway

 

[Herfried K. Wagner [MVP]]

I have an image stored in a SQL DB how can I display it in a control on a
Windows Form?

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and
Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;316887>

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in
ADO.NET and Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;317034>