How can I retrieve image from database?

[jineesh]

Hi,
Please help,

I have a problem while loading and retrieving an image from database.
I have loaded an image in the database as of type Image. I have retrieved the data from database and passed to stream. How can I load this to a picture box or to a report viewer?

regards
Jineesh

[IdanS]

In database you stored the picture as byte array right?

So now to convet it back to image you need to do:

System.IO.MemoryStream ms = new System.IO.MemoryStream(byte array of the image);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);

And use the image how you like...

If your image is not stored at the DB as byte array let me know and i will tell you how to do it!

[sknake]

In this code the "FacilityImg" column is data type "image" on the MSSQL server.

private void button2_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;";
      const string query = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000";
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            using (DataTable dt = new DataTable())
            {
              dt.Load(dr);
              File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);
            }
          }
        }
      }
    }

[IdanS]

In this code the "FacilityImg" column is data type "image" on the MSSQL server.

private void button2_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;";
      const string query = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000";
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            using (DataTable dt = new DataTable())
            {
              dt.Load(dr);
              File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);
            }
          }
        }
      }
    }

Hi sknake,
He didnt want to create a file of the image, he wanted to pull it from the DB to a MemoryStream and put it to a picture box or to a report viewer, so why use

File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);

[sknake]

Hi sknake,
He didnt want to create a file of the image, he wanted to pull it from the DB to a MemoryStream and put it to a picture box or to a report viewer, so why use

File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);

Evidently because I wasn't paying attention

private void button2_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=ServManLeather;Integrated Security=True;";
      const string query = "Select ImgNumber, FacilityImg From FacilityImg Where ImgNumber = 1000";
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            using (DataTable dt = new DataTable())
            {
              dt.Load(dr);
              //File.WriteAllBytes(@"C:\picture.bmp", (byte[])dt.Rows[0]["FacilityImg"]);
              using (MemoryStream ms = new MemoryStream((byte[])dt.Rows[0]["FacilityImg"]))
              {
                ms.Position = 0;
                ms.Seek(0, SeekOrigin.Begin);
                pictureBox1.Image = System.Drawing.Image.FromStream(ms);
                ms.Flush();
                ms.Close();
              }
            }
          }
        }
      }
    }

[tanthiamhuat]

does the above work for MySQL database? I try, it gives me this error:
It says "Unable to connect to any of the specified MySQL hosts". I have used the same connection string in other application, and it is able to retrieve successfully some other data from the same database and same table. Part of my code for MySQL is shown below:

private void GetImage_button_Click(object sender, EventArgs e)
{
const string connStr = "server=localhost;database=productcatalog;uid=root;password=12345678";
const string query = "SELECT Picture FROM Products WHERE ProductID = 1004";
using (MySqlConnection conn = new MySqlConnection(connStr))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
using (MySqlDataReader dr = cmd.ExecuteReader())
{
using (DataTable dt = new DataTable())
{
dt.Load(dr);
using (MemoryStream ms = new MemoryStream((byte[])dt.Rows[0]["Picture"]))
{
ms.Position = 0;
ms.Seek(0, SeekOrigin.Begin);
pictureBox1.Image = System.Drawing.Image.FromStream(ms);
ms.Flush();
ms.Close();
}
}
}
}
}


}

[tanthiamhuat]

sorry, my above code works perfectly now.

[ddozkaya]

Hi,
i got an error from this line

pictureBox1.Image = System.Drawing.Image.FromStream(ms);

the error is
"Parameter is not valid" how can i solve this problem ?

Thankyou...

[Momerath]

Just a comment about line 20 in your code above. You don't ever have to Flush a memory stream. It doesn't do anything.