I am looking at blobs in SQL Server.

Just to start with I am getting a single northwind employee entity.

I want to be able to use the image in the entity and use this with a standard PictureBox control.

I have tried this

  private void button1_Click(object sender, EventArgs e)
    {
        EmployeeEntity ThisChap = new EmployeeEntity(2);

        pictureBox1.Image = byteArrayToImage(ThisChap.Photo);
    }

    public Image byteArrayToImage(byte[] byteArrayIn)
    {
        MemoryStream ms = new MemoryStream(byteArrayIn);
        Image returnImage = Image.FromStream(ms);
        return returnImage;
    }

I get this exception

System.ArgumentException was unhandled Message="Parameter is not valid." Source="System.Drawing"

Ok I know that the images stored in Northwind are pretty crap but I thought I would get further than this.

There is not much for handling blobs on your site. Most of what I found was how to exclude them in a fetch.

Please check the ASP.NET 2.0 databinding example not the CRUD one. http://www.llblgen.com/pages/secure/ListDownloads.aspx?ProductVersion=6

It's using the same database to display employee information along with their images.

Thanks Walaa

I removed the OleHeader bytes and it works and displays really crap images now. (one would think they could have done better with the images)

As others viewed this and as your example used Response.BinaryWrite(strippedImageData);

my code for winforms is

   private void button1_Click(object sender, EventArgs e)
    {
        EmployeeEntity ThisChap = new EmployeeEntity(2);

        pictureBox1.Image = byteArrayToImage(ThisChap.Photo);
    }

    public Image byteArrayToImage(byte[] byteArrayIn)
    {
        return byteArrayToImage(byteArrayIn,true);
    }

    public Image byteArrayToImage(byte[] byteArrayIn, bool stripOleHeader)
    {
        int strippedImageLength = byteArrayIn.Length - (stripOleHeader ? 78 : 0);
        byte[] strippedImageData = new byte[strippedImageLength];
        Array.Copy(byteArrayIn, (stripOleHeader ? 78 : 0), strippedImageData, 0, strippedImageLength);
        MemoryStream ms = new MemoryStream(strippedImageData);
        return Image.FromStream(ms);
    }

All cool now