VB.NET - bind image in vb.net datagridview - Asked By kiruba .e on 19-Jun-12 03:12 AM

Hi,

I want to bind image from access database into datagridview vb.net windows application, just like binding of text.


So, how to do this?
pls help me

thanks
kiruba.e

reference from-

http://vb.net-informations.com/datagridview/vb.net_datagridview_image.htm

Imports System.Data.SqlClient
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        DataGridView1.ColumnCount = 3
        DataGridView1.Columns(0).Name = "Product ID"
        DataGridView1.Columns(1).Name = "Product Name"
        DataGridView1.Columns(2).Name = "Product_Price"

        Dim row As String() = New String() {"1", "Product 1", "1000"}
        DataGridView1.Rows.Add(row)
        row = New String() {"2", "Product 2", "2000"}
        DataGridView1.Rows.Add(row)
        row = New String() {"3", "Product 3", "3000"}
        DataGridView1.Rows.Add(row)
        row = New String() {"4", "Product 4", "4000"}
        DataGridView1.Rows.Add(row)

        Dim img As New DataGridViewImageColumn()
        Dim inImg As Image = Image.FromFile("Image Path")
        img.Image = inImg
        DataGridView1.Columns.Add(img)
        img.HeaderText = "Image"
        img.Name = "img"

    End Sub
End Class

Use this code
--------
Get The image Path from the database and then do the following :
Dim image As Image =  Image.FromFile("image path")
Dim ImageColumn As DataGridViewImageColumn =  New DataGridViewImageColumn()
ImageColumn.Image = image
ImageColumn.Name = "Name"
ImageColumn.HeaderText = "Nice Name"
dataGridView1.Columns.Insert(0, ImageColumn)