Your best bet, especially to prevent SQL injection attacks, instead, would be to use Parameterized Queries.
Here's a 2 part tutorial on that subject:
http://aspnet101.com/aspnet101/tutorials.aspx?id=1
David Wier
MVP/ASPInsider
http://aspnet101.com http://aspexpress.com
"Eric Layman" <namyalcire[at no spam]gmail.comwrote in message news:11*************@sp6iad.superfeed.net...
Hi,
I've saved data into the db by doing a replace() on single quote.
Right now on data display on a datagrid, it shows double single quote.
How do I make changes during run time of datagrid so that the double single quote will be replaced as single quote?
Pls advise.
Thanks