Retrive Image From Folder and Display In DataGridview

Prakash Mondal

Database Table:

EmpID	Name	Photo
E123	PRAKASH	E123.JPG

And after registration Image is saved E:\RegisterPhoto\E123.JPG

I want to display these records with Photo in dataGridview using C# Windows Form Application.

DataGridView:

Employee No	Employee Name	Photo
E123	PRAKASH	Photo will display

I use dataGridViewImageColumn but what is the code?

con.open();

SqlDataAdapter da=new SqlDataAdapter ("select * from emp",con);

DataTable dt=new DataTable();

da.Fill(dt);

con.close();

dataGridViewAutoGenerateColumn=false;

dataGridView1.dataSource=dt;

Please solve this problem.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah8y ago
may be this can help:
http://www.c-sharpcorner.com/UploadFile/009464/insert-images-into-datagridview-in-windows-application-using/
Prakash Mondal8y ago
Hi! Nilesh Shah
I apply this work Windows Form Application using C# not ASP.NET.

Please solve this.
Ramesh Palanivel8y ago
Hi Prakash,

Refer this URL,

http://www.c-sharpcorner.com/UploadFile/009464/insert-images-into-datagridview-in-windows-application-using/
Nilesh Shah8y ago
your images from local E:\ cannot be dispalyed in gridview

those images need to be hosted in a folder in IIS server, then you will have a URL for that

once you have URL, then use below code:
protected void gridView1_RowDataBound(Object sender, GridViewRowEventArgs args)
    {
     if(args.Row.RowType == DataControlRowType.DataRow)
     {
      Image img = (Image) e.Row.FindControl("Image1");
      img.ImageUrl = setImageURLHere;
     }
    }