Javascript Error on a GridView templated column where data can contain single quote

[Anonieko]

Hello ASPNET guru's,

What is a clean way to go around the problem of displaying a GridView
templated column where data can contain Single Quote ( ' )?

I maybe too naive, but this is of course a common scenario.

Scenario:

* My database returns names that can contain single quote.
* For example: O'byran, D'Ottwa, Osan's , and so on.
* I use a Gridview to view the data ( ASPNET 2.0 RTM)
* If that GridView column is a Bound Column. NO PROBLEM.
* If you convert that column into a Templated Column, error on
javascript on runtime.


Right now, I just remedy this by going to the database SELECT
statement (or stored proc) and removing the single quote. But what is
the real solution here?

Thanks,

 

[OHM \( One Handed Man \)]

First of all this should not normally be a problem, we do this all the time
with single quotes in template fields and dont experience any javascript
errors.

1.) How and what are you binding your gridview to ?
2.) At what point is the javascript error occuring and what code is failing
( Post it )
3.) Is there any code you are running specific to the textboxes or whatever
controls you are using ?

 

[Anonieko]

Thanks for the clues.

The problem is not on the template but on a javascript error in the
page.

 

[PeterDew]

Anonieko,

Do you generate your own javascript code somewhere in the events of the gridview ?
I had a similar problem when showing a special formatted tooltip for each row.
On each row I added an attribute 'onmouseover' and set the tooltip.
There I had to convert all single quotes with the HTML code "'"

HTH