Encoding string for apostrophe in asp.net

Question

I am having a problem trying to resolve an apostrophe related issue.
I have searched SO, but could not find anything that would help me.

My clientside javascript code is:

var strUserText = uSettings.replace(/'/g, "'")  

after the above line is executed, the form does a submit

document.form1.submit();  

in code behind, a class retreives those values:

sUserSettings = request.form("strUserSettings ")  

the result is a semi-truncated string.
Given the above code process flow, how can I save "John O'Brady's ASP Blog" in to a database?

I thought I was saving "John O'Brady's ASP Blog" but that isn't working.

Answer 1

Your question is quite vague. Why are you encoding the apostrophe? Is it breaking your output?

The best way to do it would be to submit your data AS-IS to the database... crappy JavaScript injection, apostrophe's, html markup, and all. Then you simply encode the output.

Server.HtmlEncode(strUserText)

Also, if you're using the latest version .NET, you can encode the output as follows

<%: strUserText %>

(assuming the strUserText string variable is set earlier in your view)