Showing image on gridview from location retrieved from db

Question

0.00/5 (No votes)

See more:

I have a gridview which i am populating using a stored procedure in the code behind.
the aspx page has only the following code.

<pre> <asp:GridView ID="GridView2" runat="server"  CssClass="GridStyle"   >
        </asp:GridView>

1 of the fields returned by sp is the location for images.the images are stored in the image folder in the project folder. So depending on the conditions the path is returned something like

'/Images/Evs/BB'

.
But the image is not appearing ,it just shows as the location as retrieved.
I do not know what is the issue and what should i do? Thanks in advance.

What I have tried:

i tried using the same image in a simple div and the image appears. please suggest .

Posted 10-Aug-19 3:37am

NoTime1234

Updated 13-Aug-19 6:02am

Add a Solution

Comments

[no name] 10-Aug-19 15:10pm

Try showing WITHOUT the grid. If that works, then worry about the grid.

NoTime1234 10-Aug-19 15:16pm

Thanks for the reply. I have already tried it outside the grid to test the path and it works alright(mentioned under "what i have tried"). what do you suggest?TIA.

Mohibur Rashid 10-Aug-19 23:52pm

Go to debug window. Check if any 404 error. Go to source and check if the image path okay or not.

2 solutions

Solution 1

Here's an old article that I wrote many years ago that may help:

Uploading and Storing Image Path to Database and Image to Folder - Part 1[^]

Uploading and Storing Image Path to Database and Image to Folder - Part 2 (Displaying of Images)[^]

Posted 12-Aug-19 10:08am

Vincent Maverick Durano

Comments

NoTime1234 13-Aug-19 13:09pm

Thanks Vincent Maverick Durano for the reply. I did come across your articles before.

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)

Richard Deeming · Accepted Answer · 2019-08-13T06:02:00

Quote:
the aspx page has only the following code.

ASP.NET
<asp:GridView ID="GridView2" runat="server" CssClass="GridStyle">
</asp:GridView>

You're relying on auto-generated columns. The problem is, there is no way for the grid to know whether the string returned from the database needs to be displayed as a string, an image, a hyperlink, or something else entirely.

You need to make the column an ImageField, or a TemplateField containing an Image control. The simplest way to do that is to set the AutoGenerateColumns property[^] to false and manually create the columns you want to display.

Otherwise, you'd need to create a custom GridViewColumnsGenerator[^] class and set the grid's GridView.ColumnsGenerator property[^] to an instance of that class.