ASP.NET - How do you escape an apostrophe with a slash to insert in a database

Question

I am not sure how to escape an apostrophe with a slash. I am using fckeditor and fckeditor replaces all single apostrophes with double apostrophes. My code is doing the same thing so when I view the content there are two apostrophe in the html. I thought that I could escape the apostrophe with a slash and that should do the trick.

Answer 1

You should replace with

"

which is the best and sometimes only way to store quotaiton marks in text fragments.

Answer 2

According to this list of HTML entities you should use ' (but this will apparantly not work in IE) or '.

You can find more on the HTML Symbol Entities Reference.

Answer 3

You should replace double quote with

This code 9" x 9" with give you output as 9" X 9"

And if your database row contain single apostrophe, you can display by assigning that value to lable controls text property and it should work without any issues.