How to I convert to image from Byte[] Array?

Question

I am making a face recognition project. I insert a person with face image and it assigned to variable and I use variable in database.

I am inserting image to database and dataGridView. When I insert a image, it writes "Byte[] Array" on dataGridView. How to I convert to image on dataGridView or how to I send to pictureBox ? It is enough one of both.

Variable of face image and convert

 Image img = pictureBox2.Image;
 byte[] arr;
 ImageConverter converter = new ImageConverter();
 arr = (byte[])converter.ConvertTo(img, typeof(byte[]));

İnsert to database

ESG("insert into kisiler values('" + textFaceName.Text + "','" + textFaceSurname.Text + "','" + textNationality.Text + "', '" + int.Parse(textAge.Text) + "','" + cinsiyet + "','"+ arr +"')");

FYI your query is vulnerable to SQL injection attacks. Use parameterised queries. — ADyson
– ADyson, Commented Dec 31, 2020 at 10:52
To convert an image to a Byte array - take a look at: stackoverflow.com/a/3801289/9365244. — JayV
– JayV, Commented Dec 31, 2020 at 10:57

Majid Shahabfar · Accepted Answer · 2020-12-31 12:03:41Z

2

Simply you can use the following code to convert Byte Array to Image:

Image.FromStream(new MemoryStream(byteArrayIn));

Which you can put it in a function like this:

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

You can also convert your Byte Array to string and use it to bind a PictureBox like the following code. Actually, I've used it in WebApp projects and not sure if it works on yours:

string photo = "data:image/jpeg;base64," + Convert.ToBase64String(byteArray.Photo, 0, byteArray.Photo.Length);

answered Dec 31, 2020 at 12:03

Majid Shahabfar

4,9672 gold badges32 silver badges39 bronze badges

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

Comments

Kadir Çorbacıoğlu · Accepted Answer · 2020-12-31 11:47:00Z

1

From PictureBox to DB (VB Code)

Dim fs As FileStream = File.Create("profile.jpg")
ProfilePictureBox.Image.Save(fs, Imaging.ImageFormat.Jpeg)
fs.Close()
fs = File.OpenRead("profile.jpg")
Dim ms As MemoryStream = New MemoryStream
fs.CopyTo(ms)

sqlCmd.Parameters.Add("@profilePic", SqlDbType.VarBinary).Value = ms.ToArray()

From Db To PictureBox (VB Code)

Dim readByte As Byte() = sqlReader("IMG_BYTE")
Dim ms As MemoryStream = New MemoryStream(readByte)
PictureBox1.Image= Image.FromStream(ms)

From Db To DatagridView (VB Code)

Dim img As Image    
Dim readByte As Byte() = sqlReader("IMG_BYTE")
Dim ms As MemoryStream = New MemoryStream(readByte)
img = Image.FromStream(ms)

answered Dec 31, 2020 at 11:47

Kadir Çorbacıoğlu

191 bronze badge

3 Comments

Charlieface Over a year ago

Please use usings. Incidentally, VarBinary can be passed directly from a stream enclosed in SqlBytes

Nyerguds Over a year ago

There's no reason to ever save the image to disk. you can just save it to the memory stream directly.

Nyerguds Over a year ago

@Charlieface No, images require that the stream they are created from remains open during the lifetime of the image object. It's... messy.

Cleptus · Accepted Answer · 2021-07-05 06:18:46Z

0

A user named rajantawate1 in this codeproject article provided the following code:

   public byte[] ImageToByteArray(System.Drawing.Image imageIn)
    {
        using (var ms = new MemoryStream())
         {
           imageIn.Save(ms,imageIn.RawFormat);
            return  ms.ToArray();
         }
    }

edited Jul 5, 2021 at 6:18

Cleptus

3,5304 gold badges31 silver badges38 bronze badges

answered Dec 31, 2020 at 11:10

Mihir Patel

1

Collectives™ on Stack Overflow

How to I convert to image from Byte[] Array?

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related