Winforms Picturebox control

[GSSI]

I have an image data field in a datarow (as in the Northwinds demo sql
database). What is the C# instruction syntax to display it in a Winform
picturebox control.
--
GSSI

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You have to create a bitmap first
Save your image to either a temp file or to a memory stream. then use the
correct constructor of Bitmat

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"GSSI" <GS**@discussions.microsoft.com> wrote in message
news:55**********************************@microsof t.com...

I have an image data field in a datarow (as in the Northwinds demo sql
database). What is the C# instruction syntax to display it in a Winform
picturebox control.
--
GSSI

[Morten Wennevik]

Hi GSSI,

You need to remove the sql image type header before you try to do anything with the data.
Feed the byte[] to a MemoryStream. Set the position of the MemoryStream to 78 (I think this is the size of the header). Then use Image.FromStream(MemoryStream)

On Mon, 10 Apr 2006 17:10:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

I have an image data field in a datarow (as in the Northwinds demo sql
database). What is the C# instruction syntax to display it in a Winform
picturebox control.

--
Happy coding!
Morten Wennevik [C# MVP]

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"Morten Wennevik" <Mo************@hotmail.com> wrote in message
news:op.s7sun1fhklbvpo@stone...

Hi GSSI,

You need to remove the sql image type header before you try to do anything
with the data.
Feed the byte[] to a MemoryStream. Set the position of the MemoryStream
to 78 (I think this is the size of the header). Then use
Image.FromStream(MemoryStream)

I have never deal with a header in the image (or binary data) from SQL , I
store documents in an Image field and I have never need to remove any part
of it.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[GSSI]

I'm pretty green at this. How do I get the data field into a byte array?
--
GSSI
"Morten Wennevik" wrote:

Hi GSSI,

You need to remove the sql image type header before you try to do anything with the data.
Feed the byte[] to a MemoryStream. Set the position of the MemoryStream to 78 (I think this is the size of the header). Then use Image.FromStream(MemoryStream)

On Mon, 10 Apr 2006 17:10:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

I have an image data field in a datarow (as in the Northwinds demo sql
database). What is the C# instruction syntax to display it in a Winform
picturebox control.

--
Happy coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

Ok, usually you don't have to deal with the header, but if you are using the Northwind sample database, you do. If you aren't using the Northwind database, and are unaware of any header info don't adjust the position before loading the image.

On Mon, 10 Apr 2006 19:05:28 +0200, Ignacio Machin ( .NET/ C# MVP ) <ignacio.machin AT <dot.state.fl.us>> wrote:

Hi,

"Morten Wennevik" <Mo************@hotmail.com> wrote in message
news:op.s7sun1fhklbvpo@stone...

Hi GSSI,

You need to remove the sql image type header before you try to do anything
with the data.
Feed the byte[] to a MemoryStream. Set the position of the MemoryStream
to 78 (I think this is the size of the header). Then use
Image.FromStream(MemoryStream)

I have never deal with a header in the image (or binary data) from SQL , I
store documents in an Image field and I have never need to remove any part
of it.

--
Happy coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

Well, you need to query the database. This example might be helpful.

[How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET]
http://support.microsoft.com/default...b;en-us;309158

Following the sample you will end up with

MyData = (byte[])myRow["imgField"];
Continue with this
using(MemoryStream ms = new MemoryStream(MyData))
{
Image img = Image.FromStream(ms);
}
On Mon, 10 Apr 2006 19:18:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

I'm pretty green at this. How do I get the data field into a byte array?

--
Happy coding!
Morten Wennevik [C# MVP]

[GSSI]

Morten, much appreciative of your help. It's almost working but still getting
an exception when I try to load the image into the control. Code is ...

"byte[] picByte = (byte[])(drUR[0]["Picture"]);
MemoryStream msPic = new MemoryStream(picByte);
msPic.Position=78;
pictureBox1.Image = (Image)Image.FromStream(msPic);"

Any thoughts?
--
GSSI
"Morten Wennevik" wrote:

Well, you need to query the database. This example might be helpful.

[How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET]
http://support.microsoft.com/default...b;en-us;309158

Following the sample you will end up with

MyData = (byte[])myRow["imgField"];
Continue with this
using(MemoryStream ms = new MemoryStream(MyData))
{
Image img = Image.FromStream(ms);
}
On Mon, 10 Apr 2006 19:18:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

I'm pretty green at this. How do I get the data field into a byte array?

--
Happy coding!
Morten Wennevik [C# MVP]

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
is dr a datatable?

What is the error you are getting?

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[GSSI]

Ignacio:

drUR is a datarow[].
All variables seem to be initializing correctly. Moreover, that data seems
to be formatted correctly. (I can verify this by using a simple Access form
with a PictureBox control connected via an Access Project setup.)

I don't get an explicit error message because of a surrounding try/catch
construct.
--
GSSI
"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,
is dr a datatable?

What is the error you are getting?

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[Morten Wennevik]

Don't set the position if you aren't using the Northwind database.

On Mon, 10 Apr 2006 20:21:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

Morten, much appreciative of your help. It's almost working but still getting
an exception when I try to load the image into the control. Code is ...

"byte[] picByte = (byte[])(drUR[0]["Picture"]);
MemoryStream msPic = new MemoryStream(picByte);
msPic.Position=78;
pictureBox1.Image = (Image)Image.FromStream(msPic);"

Any thoughts?

--
Happy coding!
Morten Wennevik [C# MVP]

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,
Well, what are you getting in the catch ?????

Unless you post the error message I have no idea why you are having this
problem.
Also see if the InnerException is populated

BTW, did you try to save the image to disk and read the file back?
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"GSSI" <GS**@discussions.microsoft.com> wrote in message
news:42**********************************@microsof t.com...

Ignacio:

drUR is a datarow[].
All variables seem to be initializing correctly. Moreover, that data seems
to be formatted correctly. (I can verify this by using a simple Access
form
with a PictureBox control connected via an Access Project setup.)

I don't get an explicit error message because of a surrounding try/catch
construct.
--
GSSI
"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,
is dr a datatable?

What is the error you are getting?

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[GSSI]

Ignacio:

The Error Message is "INVALID PARAMETER USED.". The Inner Exception is null.

Yes, I have copied the field to disk and have been able to display it in
Paint.

Sorry for being so clutsy!
--
GSSI
"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,
Well, what are you getting in the catch ?????

Unless you post the error message I have no idea why you are having this
problem.
Also see if the InnerException is populated

BTW, did you try to save the image to disk and read the file back?
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"GSSI" <GS**@discussions.microsoft.com> wrote in message
news:42**********************************@microsof t.com...

Ignacio:

drUR is a datarow[].
All variables seem to be initializing correctly. Moreover, that data seems
to be formatted correctly. (I can verify this by using a simple Access
form
with a PictureBox control connected via an Access Project setup.)

I don't get an explicit error message because of a surrounding try/catch
construct.
--
GSSI
"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,
is dr a datatable?

What is the error you are getting?

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[GSSI]

Morten: I AM using the Northwind database!

That's why I am so frustrated. In MS Access Project, it is a simple matter
to simply point a PictureBox control at an image and it will display it. I
don't expect C# and Winforms to be that much more complicated.
--
GSSI
"Morten Wennevik" wrote:

Don't set the position if you aren't using the Northwind database.

On Mon, 10 Apr 2006 20:21:02 +0200, GSSI <GS**@discussions.microsoft.com> wrote:

Morten, much appreciative of your help. It's almost working but still getting
an exception when I try to load the image into the control. Code is ...

"byte[] picByte = (byte[])(drUR[0]["Picture"]);
MemoryStream msPic = new MemoryStream(picByte);
msPic.Position=78;
pictureBox1.Image = (Image)Image.FromStream(msPic);"

Any thoughts?

--
Happy coding!
Morten Wennevik [C# MVP]

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

The Error Message is "INVALID PARAMETER USED.". The Inner Exception is
null.

Yes, I have copied the field to disk and have been able to display it in
Paint.

Sorry for being so clutsy!

What if you keep a reference to the MemoryStream in a member variable, IIRC
you need to have the stream available always.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation