How to load data with images from database into DataGridView?

Question

I'm trying to load data from database into dataGridView, and when a row is selected, the records would get displayed on other controls, it works but not as expected, specially when there is null values on the image column, I don't know what to do next

Here's my table structure:

TABLE TblProduct
[ProductID]   INT            IDENTITY (1, 1) NOT NULL,
[ProductType] INT            NOT NULL,
[Description] NVARCHAR (MAX) NULL,
[Price]       MONEY          NULL,
[Image]       IMAGE          NULL,

Here's my Retrieve() method:

private void Retrieve()
{
    dataGridView1.Rows.Clear();

    string sql = "SELECT * FROM TblProduct";
    cmd = new SqlCommand(sql, connection);
    connection.Open();
    adapter = new SqlDataAdapter(cmd);
    adapter.Fill(dt);       

    foreach (DataRow row in dt.Rows)
    {                
        dataGridView1.Rows.Add(row[0].ToString(), row[1].ToString(), row[2].ToString(), Convert.ToDecimal(row[3]), row["Image"]);
    }
    connection.Close();
    dt.Rows.Clear();
}

Here's my MouseClick event:

private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
    typeTxt.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
    descriptionTxt.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
    priceTxt.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
    pictureBox1.Image = (Image)dataGridView1.SelectedRows[0].Cells["Image"].Value;            
}

Here's the exceptions I get when selecting a row on the dataGridView that has an image

System.InvalidCastException: 'Unable to cast object of type 'System.Byte[]' to type 'System.Drawing.Image'.'

And when selecting a row on the dataGridView that has no image

System.InvalidCastException: 'Unable to cast object of type 'System.DBNull' to type 'System.Drawing.Image'.'

Jan Muncinsky · Accepted Answer · 2017-09-03 07:38:08Z

2

You must create Image from byte array and also check DB nulls.

var value = dataGridView1.SelectedRows[0].Cells["Image"].Value
if(value != DBNull.Value)
{
   byte[] data = (byte[]) value;
   MemoryStream ms = new MemoryStream(data);
   pictureBox1.Image = Image.FromStream(ms);
}

answered Sep 3, 2017 at 7:38

Jan Muncinsky

4,4485 gold badges27 silver badges43 bronze badges

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

3 Comments

Al_HK Over a year ago

Sorry it didn't work, I put it in my foreach loop, and would get this exception: System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index'

Al_HK Over a year ago

I figured it out, I was putting it in the wrong place, I put it in the MouseClick event, and now it works, Thank so much Jan

Jan Muncinsky Over a year ago

Welcome. If it works for you, don't forget to close the question. Thanks!

Collectives™ on Stack Overflow

How to load data with images from database into DataGridView?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related