Store and retrieve html from sql server 2008 and display using ASP.NET MVC?

Question

I am trying to store HTML and hyperlinks in my SQL server 2008 database. I want to also be able to display the hyperlinks and render the HTML accordingly. I am trying to do this in ASP.NET MVC, so I tried using the HTTPUtility.HtmlEncode() method, but didn't really store it the way I wanted. So can anyone please guide me through the steps I need to take to achieve this.

Silly game. The only way to win is not to play.

Dave Markle
– Dave Markle

2010-06-02 01:22:36 +00:00
Commented Jun 2, 2010 at 1:22 — Dave Markle
– Dave Markle, Commented Jun 2, 2010 at 1:22

griegs · Accepted Answer · 2010-06-02 01:38:44Z

1

I think the best approach would be the MVC way in that you have a PartialView for each link. Then all you need to do is itterate through your collection of links and render a Partial View accordingly.

edit

When i say collection of links, i mean a collection of non html links. Just the addresses.

In your controller you might have;

List<string> links = fillList();
Return View(links);

Then in your view;

foreach(string item in Model.links)
  Html.Renderpartial("htmlLink", item);

edited Jun 2, 2010 at 1:38

answered Jun 2, 2010 at 1:24

griegs

22.8k33 gold badges132 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Store and retrieve html from sql server 2008 and display using ASP.NET MVC?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related