Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Anonieko
Guest
 
Posts: n/a
#1: Apr 8 '06
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 \)
Guest
 
Posts: n/a
#2: Apr 8 '06

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


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 ?

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net


"Anonieko" <anonieko@hotmail.com> wrote in message
news:1144497623.957849.137900@u72g2000cwu.googlegr oups.com...[color=blue]
> 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,
>[/color]


Anonieko
Guest
 
Posts: n/a
#3: Apr 10 '06

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


Thanks for the clues.

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

Closed Thread