unable to cast object of type system.dbnull to type system.byte[] c# MySql [duplicate]

Question

This is my code:

byte[] imgg = (byte[])(myReader["StudPic"]);
                    if (imgg == null)
                    {
                        pictureBox11.Image = defaultpic;
                    }
                    else
                    {
                        MemoryStream mstream = new MemoryStream(imgg);
                        pictureBox11.Image = Image.FromStream(mstream);
                    }

I got this error: unable to cast object of type system.dbnull to type system.byte[]
Data type is Blob. But if it has a value, it works fine, it fetches the image.

Usman · Accepted Answer · 2017-02-22 02:56:13Z

0

you can add a condition to check weather it has value or not

if(myReader["StudPic"] != System.DBNull.Value))
{
  byte[] imgg = (byte[])(myReader["StudPic"]);
  pictureBox11.Image = defaultpic;
}

answered Feb 22, 2017 at 2:56

Usman

4,7032 gold badges19 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

unable to cast object of type system.dbnull to type system.byte[] c# MySql [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related