Insert image into datagridview

Expand Post »

I have created an image column in my datagridview and want to populate the grid based on the result of a database query. I'm able to pull the data from the database and populate the fields fine, but the image column where I want to display the image shows a broken image, this is the code I'm using:

vb Syntax (Toggle Plain Text)
        Dim thispri As Bitmap
 
        Do
            While SQLdr.Read() 
                'Build Grid Data
                If (SQLdr("priority") = "high") Then
                    thispri = New Bitmap("C:\VB...\hpri.bmp")
                ElseIf (SQLdr("priority") = "medium") Then
                    thispri = New Bitmap("C:\VB...\mpri.bmp")
                ElseIf (SQLdr("priority") = "low") Then
                    thispri = New Bitmap("C:\VB...\lpri.bmp")
 
                End If
                mainData.Rows.Add(...)
 
 
            End While
        Dim thispri As Bitmap

        Do
            While SQLdr.Read() 
                'Build Grid Data
                If (SQLdr("priority") = "high") Then
                    thispri = New Bitmap("C:\VB...\hpri.bmp")
                ElseIf (SQLdr("priority") = "medium") Then
                    thispri = New Bitmap("C:\VB...\mpri.bmp")
                ElseIf (SQLdr("priority") = "low") Then
                    thispri = New Bitmap("C:\VB...\lpri.bmp")

                End If
                mainData.Rows.Add(...)


            End While

I'm using the full path to the images, shortened here because of longtail location.

Similar Threads

insert image into mysql in Visual Basic 4 / 5 / 6
Image in DataGridView in C#
How to insert image in directory using mySQL in PHP
How to insert image in MySQL....... in PHP
how to insert an image as the flash background in Graphics and Multimedia

StatiX

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

32 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Returning a Generic List

Next Thread in VB.NET Forum Timeline: limit forms open through MDI to 1

DaniWeb Message

Cancel Changes

User Name
Password