How to read image from database

Question

OleDbCommand and = new OleDbCommand();
c.Open();
and.Connection = c;
and.CommandText = "SELECT * FROM MaleShoes WHERE IDhere=ID ";
OleDbDataReader read = and.ExecuteReader();
while (read.Read())
{
    label6.Text = (read[1].ToString());
    textBox1.Text = (read[2].ToString());
    pictureBox1.Image = (read[3].ToString());  
}

c.Close();

I got this error:

Error 1 Cannot implicitly convert type 'string' to 'System.Drawing.Image'

How should I fix it?

My pictures are in my database on the third column.

The column in your database, does it hold the file (i.e. a blob field) or does it hold a path and filename of the picture? — nvoigt, Mar 05 '13 at 07:09
As a sidenote, you should never "SELECT *" and rely on the position of your columns in the result. Name the columns either in the SELECT-statement or when reading from the DataReader. — nvoigt, Mar 05 '13 at 07:12
and also the error says it all, you tried to put an image which is actually a `string` int the `read[3].ToString()`, you need to convert it first into `bytes` using the 2 answers below :) — Pyromancer, Mar 05 '13 at 07:25
May I suggest to not use DB to store images? Take a look to this: http://stackoverflow.com/questions/1234202/storing-images-db-or-file-system — Andrea Girardi, Mar 05 '13 at 08:47

score 6 · Accepted Answer · answered Mar 05 '13 at 07:14

6

If you your database column contains the path to the image file, you should write:

pictureBox1.Image = Image.FromFile((string)read[3]);

If it is the image data (binary), you should write:

var bytes = (byte[])read[3];
using(MemoryStream ms = new MemoryStream(bytes))
{
    pictureBox1.Image = Image.FromStream(ms);
}

answered Mar 05 '13 at 07:14

Mohammad Dehghan

17,853
3
55
72

in using this how what is the format of the path of image? is it like this @"....\image.jpg" – YOUn'Me Mar 05 '13 at 08:04
@YOUn'Me The path can be relative path (`@".\Images\1.png"`) or abdolute path (`@"D:\Project\Images\1.png"`) to the image file. – Mohammad Dehghan Mar 05 '13 at 09:04

score 4 · Answer 2 · answered Mar 05 '13 at 07:13

4

Hope this help (in case you are storing a binary):

pictureBox1.Image = byteArrayToImage((byte[])read[3]);

And your method

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

answered Mar 05 '13 at 07:13

Alex

8,827
3
42
58

1

don't forget `using System.IO` :) – Pyromancer Mar 05 '13 at 07:14
it says parameter is not valid. – YOUn'Me Mar 05 '13 at 08:04
See http://www.codeproject.com/Articles/90908/Saving-OLE-Object-as-Image-Datatype-in-SQL It contains almost the same example. – Alex Mar 05 '13 at 08:21

score 1 · Answer 3 · answered Mar 05 '13 at 07:27

1

you can also use this

  byte[] imagebyte = (byte[])read[3].ToString();

  MemoryStream ms = new MemoryStream();
  ms.Write(imagebyte, 0, imagebyte.Length);
  Bitmap bmp = new Bitmap(ms);
  pictureBox1.Image = bmp;

answered Mar 05 '13 at 07:27

Pyromancer

2,429
5
19
28

` byte[] imagebyte = (byte[])read[3].ToString();` what is read there? – lexter Mar 15 '13 at 03:05

score 0 · Answer 4 · answered Mar 05 '13 at 07:23

0

You can try this:

MemoryStream ms = new MemoryStream((byte[])read[1]);

pictureBox1.Image = Image.FromStream(ms);

answered Mar 05 '13 at 07:23

Vishal Suthar

17,013
3
59
105

How to read image from database

4 Answers4