Conditional ImageURL asp.net

Question

I have a table with values

ID     PicURL            FilePath
1      www.a.com/1.png   NULL
2      NULL              ~/Images/2.jpeg

In code behind I have

<asp:Image ID="imageControl" runat="server" Width="100" ImageUrl='<%#Eval("FilePath")%>'></asp:Image>

How do I include the case when FilePath is null and ImageURL has to get value from PicURL?

Thanks Rashmi

What part of the code is reading the table? Isn't there a SQL query someplace? — abhi
– abhi, Commented Jan 29, 2014 at 18:34
Is it always the case that one or the other is null? What if both are populated? Assuming FilePath takes precedence? — James Lawruk
– James Lawruk, Commented Jan 29, 2014 at 19:23

MikeSmithDev · Accepted Answer · 2014-01-29 18:52:53Z

2

If you don't want to change data structure, or query... and want to do it in code front, you can do it like this (though it's cleaner to do in ItemDataBound):

<asp:Image ID="imageControl" runat="server" Width="100" ImageUrl='<%# DataBinder.Eval(Container.DataItem, "FilePath") != null ? Eval("FilePath") : Eval("PicURL")  %>'></asp:Image>

answered Jan 29, 2014 at 18:52

MikeSmithDev

15.8k4 gold badges61 silver badges91 bronze badges

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

Comments

Alireza Kousha · Accepted Answer · 2014-01-29 18:34:59Z

0

Why don't you just create a calculated field/property and do the logic there and then bind that property?

answered Jan 29, 2014 at 18:34

Alireza Kousha

511 silver badge1 bronze badge

1 Comment

Bernard Saucier Over a year ago

Would probably belong in the comments section, rather than in the answers.

James Lawruk · Accepted Answer · 2014-01-29 19:37:33Z

0

You could change your SQL Query to return either PicURL or FilePath based on whichever value is not null. You can reverse the order of the field list depending on which field should take precedence.

SELECT Id, Isnull(PicURL, FilePath) as ImageUrl from tblImage

<asp:Image ID="imageControl" runat="server" 
Width="100" ImageUrl='<%#Eval("ImageUrl")%>'></asp:Image>

answered Jan 29, 2014 at 19:37

James Lawruk

31.5k19 gold badges135 silver badges141 bronze badges

Collectives™ on Stack Overflow

Conditional ImageURL asp.net

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related