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]

In article <uX**************@TK2MSFTNGP12.phx.gbl>, C CORDON wrote:

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
--
Tom Shelton [MVP]

[Mike McIntyre [MVP]]

This link should help:

http://support.microsoft.com/default...b;en-us;326502
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

"C CORDON" <tc******@hotmail.com> wrote in message
news:uX**************@TK2MSFTNGP12.phx.gbl...

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

TIA!

[Herfried K. Wagner [MVP]]

"C CORDON" <tc******@hotmail.com> schrieb:

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>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[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

:)
"Tom Shelton" <to*@YOUKNOWTHEDRILLmtogden.com> wrote in message
news:eY**************@tk2msftngp13.phx.gbl...

In article <uX**************@TK2MSFTNGP12.phx.gbl>, C CORDON wrote:

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
--
Tom Shelton [MVP]