Read data from SQL into datagridview and replace values by images

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to read a table from SQL containing 8 columns with values from 1 to 3, and if the value in a cell is 1, the i want the datagridview to show image 1 in the cell as a replacement for the integer value of 1, if the value is 2, then show image 2 etc.

Is there an easy solution for converting from integer to image?

Thanks

Br
Kenneth

What I have tried:

I have read the data from SQL into a dataadapter and dataset and bound that to the datagridview, not sure that is the way to go. Maybe i should replace when in the dataset, before filling the datagrid?

Posted 17-Sep-19 7:59am

kjohansen2000

Updated 17-Sep-19 23:37pm

Add a Solution

Comments

CHill60 18-Sep-19 3:58am

"Is there an easy solution for converting from integer to image?" No. In fact it is impossible. What you really want to do is determine which image to use from the integer reference. That is a simple look up so what is your problem?

kjohansen2000 18-Sep-19 4:32am

A conversion from integer to image :) if you read above that, i wrote what i intend.

My problem is to replace the cell content from an integer to an image depending on the value in the cell. I didnt write that it is in a datagridview, that i want to manipulate cells.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Accepted Answer · 2019-09-17T23:38:00

Hi kjohansen2000,

please gothrough below steps,

VB

'implement event "DataBindingComplete" for your dataGridView. In that...
     'start a for loop for each row of grid...
          'identify your targeted cell value in the row to write if else condition...
               'if value is XX then replace value with image.
                 Dim Img As New DataGridViewImageCell
                 'Set image value
                 Img.Value = Image.FromFile("..Path of image...")
                 'Add the image cell to a row
                 DataGridView1.Rows(0).Cells.Add(Img)

here are link you can take as reference for few of above steps.
dataBind event DataGridView.DataBindingComplete Event (System.Windows.Forms) | Microsoft Docs[^]
loading image in datagrid cell displaying image in datagridviewimagecolumn in vb.net - Stack Overflow[^]

Hope that helps
Happy Coding! :)