Add Image to a datatable and gridview

Question

Trying to add a jpg image to the datatable dtsun. How do I do this?

    Dim dtsun As New DataTable()
    dtsun.Columns.Add("col1")
    dtsun.Columns.Add("col2")
    dtsun.Columns.Add("col3")
    dtsun.Rows.Add(ImageUrl("~/jpg/" & col1name & ".jpg"), ImageUrl("~/jpg/" & col2name & ".jpg"), ImageUrl("~/jpg/" & col3name & ".jpg"))

    GridView1.DataSource = dtsun
    GridView1.DataBind()

Possible duplicate of [add image to datatable or gridview](https://stackoverflow.com/questions/17701661/add-image-to-datatable-or-gridview) — ArunPratap, Jun 23 '18 at 05:18

score 0 · Answer 1 · answered Jun 23 '18 at 16:53

0

You can add directly a image column to grid view.. so you don't need to add an image column to dt. This can be done like this

    GridName.Columns.Clear()
    Dim ds As DataSet = SqlHelper.ExecuteDataset(connect(), CommandType.StoredProcedure, ProcedureName, Parameter)
    Dim DT As DataTable = ds.Tables(0)
    GridName.DataSource = DT
    Dim img As New DataGridViewImageColumn()
    Dim inImg As System.Drawing.Image = My.Resources.edit
    img.Image = inImg
    img.HeaderText = "Edit"
    img.ToolTipText = "Edit"
    GridName.Columns.Add(img)
    img.DefaultCellStyle.BackColor = System.Drawing.Color.MediumAquamarine

answered Jun 23 '18 at 16:53

Amrita Srivastava

384
1
7

1

I assume SqlHelper is a class in your project. .Net has an SqlHelper class that is for internal use. Careful to not get a conflict. – Mary Jun 24 '18 at 01:17
Yup Mary.. I have made a sqlHelper class.. Thax for yor advice :) – Amrita Srivastava Jun 24 '18 at 06:32

Add Image to a datatable and gridview

1 Answers1