Retrieve image from database in c#

Question

i have a table in my database in which contains an Image_ID, Image, Image_Name and Recipe_ID.

I am trying to edit these in a seperate form. So when a row in the dataGridView is selected it will open up in the edit form with the relevant areas filled out with data.

I am able to do it with all data apart from the Image. Obviously i need to somehow convert it as like i have done with the text fields but i have no idea on how to do so.

Edit Image Row

//Edit image row
        private void EditImageBtn_Click(object sender, EventArgs e)
        {
            try
            {
                EditImageForm Image = new EditImageForm();

                Image.imageidTxt.Text = this.imageGridView.CurrentRow.Cells[0].Value.ToString();
                //Image.picImg.Text = this.imageGridView.CurrentRow.Cells[1].Value.ToString();
                Image.nameTxt.Text = this.imageGridView.CurrentRow.Cells[2].Value.ToString();
                Image.recipeCombo.Text = this.imageGridView.CurrentRow.Cells[3].Value.ToString();

                Image.ShowDialog();
                loadImageTable();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }

What's the data type of the image ? Is it stored as a BLOB or varbinary in the database? And is your issue converting that back to a visual image? — David Oesterreich
– David Oesterreich, Commented Apr 5, 2016 at 17:35
@DavidOesterreich Image and its stored as Bytes. I have got my upload working but not able to retrieve it to view it correctly. — D B
– D B, Commented Apr 5, 2016 at 17:36

David Oesterreich · Accepted Answer · 2016-04-05 17:43:13Z

2

If your image is stored bytes, you can try something similar to the below to convert the bitmap to an Image type:

byte[] bitmap = this.imageGridView.CurrentRow.Cells[1].Value;    
Image image = Image.FromStream(new MemoryStream(bitmap))

More info: https://msdn.microsoft.com/en-us/library/9t4syfhh.aspx

answered Apr 5, 2016 at 17:43

David Oesterreich

3411 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

Retrieve image from database in c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related