How to retrieve blob image in mysql to datagridview using C#

Question

I am using this syntax where the dr.getValue(6) is the blob image from mysql.

public void LoadRecords()
{
    metroGrid1.Rows.Clear();
    cm = new MySqlCommand("Select * from tblaccnt", cn);

    dr = cm.ExecuteReader();
    while (dr.Read())
    {
        metroGrid1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3), dr.GetValue(4), dr.GetValue(5), dr.GetValue(6));

    }

    dr.Close();
}

But I always end up with Parameter is not valid Exception. Thanks in advance for the help

caner · Accepted Answer · 2017-04-24 15:14:00Z

0

You have to set byte array for your image

  (byte[])reader["ImageData"]

And then convert to Image

 MemoryStream ms = new MemoryStream((byte[])reader["ImageData"]);
 Image returnImage = Image.FromStream(ms);

answered Apr 24, 2017 at 15:14

caner

7316 silver badges21 bronze badges

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

2 Comments

Ako C Estong Over a year ago

I still got Parameter not valid at the Image.FromStream(ms);

caner Over a year ago

try this approuch for converting your byte array stackoverflow.com/a/17668083/2470530

Collectives™ on Stack Overflow

How to retrieve blob image in mysql to datagridview using C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related