Insert images from mysql database into C# datagrid view

Question

I have a database which contains many columns, one of the columns is an image column , this contains the image of a particular person in raw format. I want to put this image on datagrid view in C# . I am able to show all other data except the image.

Satinder singh · Accepted Answer · 2017-10-26 06:33:11Z

1

You can use handler to display image in gridview , your html markup look like inside

Gridview ItemTemplate set image control src as src=~/ShowImage.ashx?id=" + id

where ShowImage.ashx is your handler which return MemoryStream((byte[])img);

Here is a similar article how to get binary data and display as image

https://codepedia.info/convert-binary-data-to-image-save-and-retrieve-image-from-binary-data-asp-net-c/

In your case your querystring is characterID

so your image src would be src=~/ShowImage.ashx?id=" + characterID

edited Oct 26, 2017 at 6:33

Satinder singh

10.2k18 gold badges64 silver badges102 bronze badges

answered Mar 30, 2014 at 11:47

Ehsan Sajjad

62.6k16 gold badges112 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ynk 1993 · Accepted Answer · 2014-03-30 11:47:48Z

0

OKay got it . you do the normal updating of datagrid view with ur query and then make sure u set your datagrid view columns and rows to autosize so that u can see ur images

answered Mar 30, 2014 at 11:47

Ynk 1993

691 silver badge8 bronze badges

Collectives™ on Stack Overflow

Insert images from mysql database into C# datagrid view

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related