retrieve html content from database and parse to string

Question

How do i parse html content stored in database in web form application? For instance: I have a column in table that stores the content like this:

<b>Hello</b><i>World</i>

I need to retrieve the content and save to word document. So, how can i get the string text equivalent to: Hello World

What have you done so far? you can use HTML Renderer for the same. — Mohit S
– Mohit S, Commented Dec 16, 2016 at 4:16
i tried html agility pack. but it seems like it works while loading from a site with a url like this: var web = new HtmlWeb(); var doc = web.Load(url); This way it returns a HtmlDocument object. — user3399326
– user3399326, Commented Dec 16, 2016 at 4:20
check if the below stack overflow post helps you. stackoverflow.com/questions/2363993/… — Kalyan
– Kalyan, Commented Dec 16, 2016 at 4:23
hi kalyana unfortunately the solution in the link only works with office interop. I am unable to use that. — user3399326
– user3399326, Commented Dec 16, 2016 at 4:32

Rai Vu · Accepted Answer · 2016-12-16 04:19:07Z

0

f the string is encoded in your database, then you need to call WebUtility.HtmlDecode:

@Html.Raw(WebUtility.HtmlDecode(someString))

answered Dec 16, 2016 at 4:19

Rai Vu

1,6151 gold badge23 silver badges35 bronze badges

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

2 Comments

Hi will this work with Web forms? I am not using mvc.