asked on 5/5/2006

how to escape single quotes in a DataBinder on the client - side

I have a link in a dataList like so:

<a href="javascript:openMap('showRoomLocation.aspx?room=<%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum") %>');" class="RedBold"><%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum") %></a>

Is there a way to escape single quotes in the room number in the href?

ASP.NET

Last Comment

Paul Kahl

5/5/2006

Guy Hengel [angelIII / a3]

5/5/2006

you have to duplicate them.

Paul Kahl

5/5/2006

ASKER

what i'm looking for is this:

if
<a href="javascript:openMap('showRoomLocation.aspx?room=<%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum") %>');" class="RedBold"><%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum") %></a>

would print out

<a href="javascript:openMap('showRoomLocation.aspx?room=men's restroom');" class="RedBold">men's restroom</a>

then I want it to print out

<a href="javascript:openMap('showRoomLocation.aspx?room=men\'s restroom');" class="RedBold">men's restroom</a>

how do I do that, on the fly?

ASKER CERTIFIED SOLUTION

rundkaas

5/5/2006

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Paul Kahl

5/5/2006

ASKER

That's it exactly! Thank you!

Paul Kahl

5/5/2006

ASKER

well - almost it: one small change:

<a href="javascript:openMap('showRoomLocation.aspx?room=<%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum").ToString().Replace("'","\'") %>');" class="RedBold"><%# DataBinder.Eval(Container.DataItem, "vchrSRRoomNum") %></a>

replaced \\ with \ in the replace command.

Thank you a ton!