Image display issue in datagridview from imagepath stored in database(sqlite) in windows form(C#)

Question

I am working C# desktop application with sqlite. Store Image path properly as

like C:\Users\USER\Pictures\pms_1484911839.45213251.jpg.

And I want to display the images in datagridview. My Code

private void loadTable(){
conn.Open();
SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter("SELECT * FROM products", conn);
DataTable dt = new DataTable();
dataAdapter.Fill(dt);
foodListView.AutoGenerateColumns = false;
foodListView.AllowUserToAddRows = false;
foodListView.RowHeadersVisible = false;
foodListView.DataSource = dt;

DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
Image img;
int i = 0;
imageColumn.HeaderText = "Image";
imageColumn.Name = "image";
foodListView.Columns.Insert(3, imageColumn);

foreach (DataRow dr in dt.Rows)
{
    img = Image.FromFile(@dr["image"].ToString());
    foodListView.Rows[i].Cells["image"].Value = img;
    i++;
}

conn.Close();}

My Output is like

Where is my problem. Thank you.

When you debug, what is the value of @dr["image"].ToString() for any given record which isn't being displayed properly? What is the resulting img? I'd also recommend declaring the img variable inside the loop so you're not potentially over-writing all previous images with each iteration of the loop. It's possible that only the last image is broken, but is also overwriting the rest of them. — David
– David, Commented Apr 23, 2018 at 14:35
When I debug I got C:\Users\USER\Pictures\pms_1484911839.45213251.jpg which is exists. I also declare img inside the loop. No change happen. — Iftakharul Alam
– Iftakharul Alam, Commented Apr 23, 2018 at 14:42
Yes. Like exactly same as C:\Users\USER\Pictures\pms_1484911839.45213251.jpg — Iftakharul Alam
– Iftakharul Alam, Commented Apr 23, 2018 at 14:50

Baskar John · Accepted Answer · 2018-04-24 05:14:51Z

2

//foreach (DataRow dr in dt.Rows)
//{
//    img = Image.FromFile(@dr["image"].ToString());
//    foodListView.Rows[i].Cells["image"].Value = img;
//    i++;
//}
foodListView.CellFormatting += foodListView_CellFormatting;



 private void foodListView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
    {
        if (foodListView.Columns[e.ColumnIndex].Name == "image")
        {
            e.Value = Bitmap.FromFile(e.Value.ToString());
            e.FormattingApplied = true;
        }
    }

try to apply cellformatting. make sure column is mapped with respective field.

answered Apr 24, 2018 at 5:14

Baskar John

7265 silver badges10 bronze badges

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

5 Comments

Iftakharul Alam Over a year ago

System.NullReferenceException: 'Object reference not set to an instance of an object.'  System.Windows.Forms.ConvertEventArgs.Value.get returned null.

on line e.Value = Bitmap.FromFile(e.Value.ToString());

Baskar John Over a year ago

imageColumn.DataPropertyName = "image"; you have to mapp the colum first

Iftakharul Alam Over a year ago

Working. Thank you. I think this is more optimize solution.

Iftakharul Alam Over a year ago

But If I recall the function again it shows error System.IO.FileNotFoundException: 'System.Drawing.Bitmap' in the line e.Value = Bitmap.FromFile(e.Value.ToString());. Any Idea why?

Baskar John Over a year ago

@IftakharulAlam check the file path. also foodListView.CellFormatting -= foodListView_CellFormatting; unsubscribe event before subscribe it.

Aousaf Rashid · Accepted Answer · 2018-04-23 14:49:30Z

0

If you want to load image from a a file into the DataGridView(in your case the path of the file is in the database) , then here's a sample code :

  Bitmap img;
  img = new Bitmap(dr[3].ToString); ////change column index as required
  DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();
  ////other codes here 
  dgv.Rows[0].Cells[3].Value = img;

Hope this helps :)

answered Apr 23, 2018 at 14:49

Aousaf Rashid

5,7986 gold badges30 silver badges51 bronze badges

7 Comments

Aousaf Rashid Over a year ago

Here i am simply using the Bitmap class ... and the op's code makes very less sense as he's,on the first hand,binding the datagridview to the datatable and then again looping through the datatable to add images to the dgv..i wonder why he didn't choose to do it all in one way

TaW Over a year ago

this will not make any difference at all. The images are not in the dbms, so he needs to fill in the images after binding.

Iftakharul Alam Over a year ago

@zackraiyan your solution isn't working. It says In valid parameter in img = new Bitmap(dr[3].ToString())

Iftakharul Alam Over a year ago

What will be the correct format? That's what I want to know.

Aousaf Rashid Over a year ago

Do u really wanna go with a datatable first ? and iterate over it twice ? there are better solutions available :)

|

Iftakharul Alam · Accepted Answer · 2018-04-24 05:05:25Z

0

Actually the code in the above working absolutely fine. But the problem was I call loadTable() before the form loaded. That's why the function creates image dispay issue. When I call the function after the form load images load properly. Thank you everyone.

answered Apr 24, 2018 at 5:05

Iftakharul Alam

3,3214 gold badges24 silver badges34 bronze badges

Collectives™ on Stack Overflow

Image display issue in datagridview from imagepath stored in database(sqlite) in windows form(C#)

3 Answers 3

5 Comments

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related