how to change image in gridview when database fields condition is satisfied?

Question

3.00/5 (2 votes)

See more:

I want to change the image in gridview .

When the conditions in database are satisfied, then the column is true, otherwise false.
and m fetching image for true and false...
then how can i do this in asp.net using sql???

Posted 13-Feb-13 1:02am

mona_12

Add a Solution

3 solutions

Solution 1

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]

It's not that you're looking for, but you can certainly have your own logic for your question.. And have a reference from given link !!

Goog Luck !

Posted 13-Feb-13 1:17am

Krunal Rohit

Solution 2

You can include an image control in itemtemplate of gridview. Then in the imageUrl property you can call a function like:

ASP.NET

<asp:image id="myImage" runat="server" imageurl="<%#SetImageUrl("DataBaseCondition")%>" />

Now in your code behind implement SetImageUrl(string _databaseCondition) function to set the url of the image.

Posted 13-Feb-13 1:35am

Zafar Sultan

Updated 13-Feb-13 2:17am

v2

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)

Asim Mahmood · Accepted Answer · 2013-02-13T02:10:00

Solution 3

Hi,
you must handle it at DataBase end.

SQL

Select t.Id, t.Name, CASE WHEN Flag = true THEN '~/Images/true.png' ELSE '~/Images/false.png' END from Table t

[Edit: Removed begging for votes]

Posted 13-Feb-13 2:10am

Asim Mahmood

Updated 13-Feb-13 7:07am

v2

Comments

mona_12 14-Feb-13 1:40am

How can i bind this image to gridview?
i used image control in item template, but image is mot dispalying.

Asim Mahmood 14-Feb-13 1:45am

Dear
Select t.Id, t.Name, CASE WHEN Flag = true THEN '~/Images/true.png' ELSE '~/Images/false.png' END as ImagePath from Table t

use it like this and bind image with this PATH

mona_12 14-Feb-13 1:55am

i tried this.
m not storing this image in database. then how can i do this ?
and i used image control. bt still image is not displayed.

Asim Mahmood 14-Feb-13 4:02am

please send me your code i'll tell you what you have to do Thanks.
syedasim8@hotmail.com
it's my email id or paste your code here.