Question:

I have an aspx text editor that allows people to type in whatever they want.  The data is inserted into SQL Server and callaed with stored procedures or regular select statements.

Of course…you wind up with people typing in special characters…example

Larry’s

And the  ‘ character causes things to bomb out.  How do I get around this?  They really need the ability to store AND recall the (Larry’s) text.

Solution:

Here is a general article:

http://aspnet101.com/aspnet101/tutorials.aspx?id=1