Hello all

There is a binding column which may be return as NULL from DataList or not. If it is not NULL then i ve to apply the Replace function

<asp:HyperLink ID="hplHotelName" CssClass="linkhotel" runat="server" NavigateUrl='<%# "/hotel/" & IIF(Eval("URLTitle") Is DBNull.Value,Replace(Replace(lcase(Eval("HotelName "))," ","-"),"&","and") & ".aspx",replace(Eval("URLTitle")," ","-") & ".aspx" ) %>' Text='<%# Eval("HotelName") %>'> </asp:HyperLink>

and i have also to check with the function like
<asp:HyperLink ID="hplHotelName" CssClass="linkhotel" runat="server" NavigateUrl='<%# "/hotel/" & IIF(Eval("URLTitle") <> "",Replace(Replace(lcase(Eval("HotelName"))," ","-"),"&","and") & ".aspx",replace(Eval("URLTitle")," ","-") & ".aspx" ) %>' Text='<%# Eval("HotelName") %>'> </asp:HyperLink>

For function both are not work.

Thanks for all thing
Phuc Hoang

What DB are you using? MSSQL, MYSQL, ACCESS,...?


Assuming you are using MSSQL why don't you use an isnull() function to convert the null value to an empty string? that whay you don't need to check if the value is null.

something like this
also i think you have to use an HTML Anchor Tag for this because server controls don't allow <% %> constructs but i don't remember if that applies on databinding, i don't think it does?

Either way it would be much simpler to just do this in your Query. You could even do the replace function in the query as well if you wanted to.

__________________
Jason Hall

Follow me on Twitter @jhall2013

I think that's a bad idea. You should test if the value is null, then execute separate instructions based on the test results.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Thanks alliancejhall
I have done it.
I am very pleasant with your helping me
Best wishes
Phuc Hoang

Glad to hear it worked for you.

__________________
Jason Hall

Follow me on Twitter @jhall2013