Display a page in browser stored in Database using asp.net and sql server

Question

I am trying to display my blog content that is stored in my database in the form of raw html tags and img tags. I tried using HTML Encode before inserting data in the database and Decode while retrieving the data. After doing so I am getting an output like this.

enter image description here

I want to get an output like this enter image description here

I tried doing this but nothing worked

//code to put this text into the database
string text = Server.HTMLEncode(userEnteredText);

//code to put while fetching data from DB
string text = Server.HTMLDecode(userEnteredText);

Please note I am using Webforms and not MVC framework

I would be obliged if anyone could help me with this.

What happens when you do not use string text = Server.HTMLDecode(userEnteredText); Can you please check. — Amit, Dec 12 '14 at 13:08
What kind of server control are you using to display the output? — Ben Robinson, Dec 12 '14 at 13:11
@Amit as mentioned above I am getting the output shown in the second image — user3818870, Dec 12 '14 at 13:41
That is probably your problem then. A `Label` will automatically HTML encode what is set in the `Text` property before rendering to the browser. Use a `Literal` instead. — Ben Robinson, Dec 12 '14 at 13:43
@BenRobinson thanks even i realized that now while searching for this problem let me try using Literalcontrol I guess this should work — user3818870, Dec 12 '14 at 13:51
@BenRobinson Could you please show me a demonstration as in how would I use the literal Control in this scenario. — user3818870, Dec 12 '14 at 14:06
@BenRobinson its not working even after doing that, is there anything I need to do in my server code — user3818870, Dec 12 '14 at 14:16
@Amit I got a solution to this i used HtmlDecode twice while entering data into database and also while fetching it from database..It displays as required..thanks for the help — user3818870, Dec 16 '14 at 06:34

score 1 · Answer 1 · edited May 23 '17 at 12:05

1

You should try LiteralControl

With this you can inject Html into your page at runtime like so:

this.Controls.Add("<h1>Hello World</h1>");
this.Controls.Add(userEnteredText);

Display a page in browser stored in Database using asp.net and sql server

1 Answers1