Displaying image from db to picturebox winforms c#

Question

Iam doing a winforms application to insert an image to a database(sql server 2008)and retrieve an image from database into a picture box.The code for inserting works perfectly.While the code for retrieving show's up an error parameter not Valid.I was trying various solutions found by goggling but none of them succeeded.

Here is my code for retrieving

           private void button2_Click(object sender, EventArgs e)
            {
 FileStream fs1 = new FileStream("D:\\4usdata.txt", FileMode.OpenOrCreate,FileAccess.Read);
        StreamReader reader = new StreamReader(fs1);
        string id = reader.ReadToEnd();
        reader.Close();
        int ide = int.Parse(id);
        con.Open();
        SqlCommand cmd = new SqlCommand("select img from tempdb where id='" + id + "'", con);
        //cmd.CommandType = CommandType.Text;
        //object ima = cmd.ExecuteScalar();
        //Stream str = new MemoryStream((byte[])ima);
        //pictureBox1.Image = Bitmap.FromStream(str);
        SqlDataAdapter dp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dp.Fill(ds);
        int c = ds.Tables[0].Rows.Count;
        if (c ==1)
        {


            Byte[] MyData = new byte[0];
            MyData = (Byte[])ds.Tables[0].Rows[0]["img"];
            MemoryStream stream = new MemoryStream(MyData);
            stream.Position = 0;
            pictureBox1.Image = Image.FromStream(stream);

        }

    }

What is the type of img field in database?

Raging Bull
– Raging Bull

2014-03-16 07:38:58 +00:00
Commented Mar 16, 2014 at 7:38 — Raging Bull
– Raging Bull, Commented Mar 16, 2014 at 7:38
@RagingBull The img field is a Image Type

Jijith
– Jijith

2014-03-16 10:08:55 +00:00
Commented Mar 16, 2014 at 10:08 — Jijith
– Jijith, Commented Mar 16, 2014 at 10:08

JC Borlagdan · Accepted Answer · 2015-04-12 12:56:15Z

2

First you must consider that the datatype in your Database of image must be VarBinary:

in your button click event:

byte[] getImg=new byte[0];
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("select img from tempdb where id='" + id + "'", con);
cmd.CommandType=CommandType.Text;
DataSet ds = new DataSet();
da.Fill(ds);
foreach(DataRow dr in ds.Tables[0].Rows)
{
   getImg=(byte[])dr["img"];
}

byte[] imgData=getImg;
MemoryStream stream = new MemoryStream(imgData);
pictureBox1.Image=Image.FromStream(stream);
}

answered Apr 12, 2015 at 12:56

JC Borlagdan

3,6535 gold badges30 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Raging Bull · Accepted Answer · 2014-03-16 07:33:24Z

0

Try this code:

To store into database:

public byte[] WinImage=new byte[0];
MemoryStream stream = new MemoryStream();
PictureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
WinImage=stream.ToArray();

And save it to the table as varbinary(max).

To retrieve the image from database:

MemoryStream stream = new MemoryStream(byte[] WinImage);
Image RetImage = Image.FromStream(stream);
PictureBox.Image = RetImage;

answered Mar 16, 2014 at 7:33

Raging Bull

18.8k13 gold badges52 silver badges56 bronze badges

1 Comment

Eric J. Over a year ago

When do you dispose of stream? When I try to dispose it right after setting PictureBox.Image = Image.FromStream(stream) I get an ObjectDisposedException. Leaving the stream around indefinitely doesn't seem wise.

Eric J. · Accepted Answer · 2015-10-08 20:20:41Z

0

You can do in this way,

Byte[] MyData = new byte[0];

MyData = (Byte[])ds.Tables[0].Rows[0]["img"];

if (MyData != null && MyData .Length > 0)  
{
    string img = Convert.ToBase64String(MyData , 0, MyData.Length);

    pictureBox1.ImageUrl = "data:image/png;base64," + img;
}

edited Oct 8, 2015 at 20:20

Eric J.

151k65 gold badges353 silver badges563 bronze badges

answered Mar 17, 2014 at 7:07

Kailas

4491 gold badge5 silver badges15 bronze badges

Collectives™ on Stack Overflow

Displaying image from db to picturebox winforms c#

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related