How to show images in DataGridView?

[forbid55]

Attachment 99251

Dim sqlcmd As String = "StoredProcedure"
Dim conn As New SqlConnection("ConnectionString")
Dim find As New SqlCommand(sqlcmd, conn)
find.CommandType = CommandType.StoredProcedure
find.Parameters.Add("@id", SqlDbType.Int).Value = txtid.Text
Dim da As New SqlDataAdapter(find)
Dim ds As New DataSet
  Try
    conn.Open()
    da.Fill(ds)
    conn.Close()
    DataGridView1.DataSource = ds.Tables(0)
    DataGridView1.Columns(0).HeaderText = "Name"
    DataGridView1.Columns(1).HeaderText = "Status"
  Catch ex As Exception
    MsgBox("Error: " & Ex.Message, MsgBoxStyle.Information, "ERROR!")
  End Try

Hello,
This example "Status" is "Bit" (True/False) and program shown in Checkbox but i wanna show only image.
Eg: True.bmp or False.gif
Thanks.

[dunfiddlin]

Interesting. So bitmaps are True and gifs are False? You'll be wanting a DataGridViewImageColumn then.

[forbid55]

"Status" column is changeable value..
How to show True.png or False.png with value?

[dunfiddlin]

You don't. Well you don't directly. You have to add the image column, hide the status column but use its values to determine which pictures to load. You can only do that the good old fashioned loop method post binding.

[forbid55]

Sorry my English a little.
imageColumn is not support fill method?
Only using while method for image show in dataGridView?

[kareninstructor]

The following VS2010 shows how to display images based on the value of a column other than the image column. Images are icon files in the project resource file. By taking your time to study the code and understand the code you should have no problem adapting what is shown to use other image types i.e. jpeg, bmp etc.

VS2010 project on SkyDrive, VB.NET Option Strict On.

[forbid55]

@kevininstructor,
Thanks for example but this code is very long and professional. I am new to VB.NET and using tiny codes.
My problem only change checkbox to image in column.
Thank you for help.

if a=True then 
a.Value = Image.FromFile("C:\Pictures\True.ico")
else
a.Value = Image.FromFile("C:\Pictures\False.ico")
end if