PictureBox && Binding

[Ginka]

I don't know if I'm doing something wrong

I'm binding others controls and it is very easy, but the pictureBox doesn't work

I mean

textBoxAny.DataBindings.Add("Text",dataSet.Tables["MyTable"],"MyTextField");[b]//OK[/b]

pictureBoxAny.DataBindings.Add("Image",dataSet.Tables["MyTable"],"MyImageField");[b]//crash[/b]

I'm using sqlServer

 

[SHelton]

You can't directly bind a BLOB field to a picture box, you need to convert it to a bitmap first:

Binding b = new Binding("Image",dataSet.Tables["MyTable"],"MyImageField");

b.Format += new ConvertEventHandler(b_Format);

pictureBox1.DataBindings.Add(b);

private void b_Format(object sender, ConvertEventArgs e)
{
	byte[] b = (byte[])e.Value;

	System.IO.MemoryStream ms = new System.IO.MemoryStream(b);

	Bitmap bmp = new Bitmap(ms);

	ms.Close();

	e.Value = bmp;
}