HTML encoding in C# -- is there any other way

Question

Is there any way to do HTML encoding in C# when characters like apostrophes encoded like ' instead of ' as in case of HttpUtility.HtmlEncode method?

I have the DB that contains a string like this:

str&apos;str

and I need to select it via SQL query when the user type "str'str" in the TextBox. So I want to encode it to the same string first and select it via LIKE operator then.

Thanks in advance.

How do you mean "is there any other way"? A dozen, but anything specific? — Patrick Hofman
– Patrick Hofman, Commented Mar 31, 2015 at 11:15
@Patrick Hofman @Alejandro I need to encode characters like apostrophes as ' instead of ' — FrozenHeart
– FrozenHeart, Commented Mar 31, 2015 at 11:17
@PatrickHofman He stores strings containing "'" as a string, for example "Mike's". Now when from his UI he wants to search "Mike's", he wants to convert the search term to "Mike's" instead of "Mike&39;s", so he can perform a string search. One way could be to store "Mike's" in the database instead of "Mike's"... — Thorsten Dittmar
– Thorsten Dittmar, Commented Mar 31, 2015 at 11:31

Crowcoder · Accepted Answer · 2015-03-31 11:56:15Z

4

apos is an xml entity, not really HTML. You can use the AntiXSS library to encode as xml to get your apostrophes, but I don't know what other data you need to encode and if it will meet your needs but worth a try:

System.Web.Security.AntiXss.AntiXssEncoder.XmlEncode("Mike's")

answered Mar 31, 2015 at 11:56

Crowcoder

11.6k3 gold badges39 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BDH · Accepted Answer · 2015-03-31 11:37:23Z

1

        string teststr = " > < & ";
        string zoo = HttpUtility.HtmlEncode(teststr);

zoo == " & gt; & lt; & amp; " (Minus the spaces between the ampersand and alpha characters)

answered Mar 31, 2015 at 11:37

BDH

1568 bronze badges

Comments

mrsen · Accepted Answer · 2015-03-31 12:11:06Z

1

string str = "str'str";

Option 1:

System.Security.SecurityElement.Escape(str);

Option 2:

string encoded = str.Replace("&", "&amp;").Replace("<", "&lt;").Replace(">", "&gt;").Replace("\"", "&quot;").Replace("'", "&apos;");

for more info take a look at xml encoding

edited Mar 31, 2015 at 12:11

answered Mar 31, 2015 at 11:48

mrsen

1274 bronze badges

Collectives™ on Stack Overflow

HTML encoding in C# -- is there any other way

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related