Save formated text from MVC 3 app to MSSQL Database

Question

In my MVC 3 application i need to be able to edit text with formatting (ex bold text, linebreaks eks.), and send that edited text to a pdf document. What i want is to put that formated text inside of a MSSQL DB, and be able to retrive it when needed.

Right now i am stuck at basics, when i am saving text to DB, db returns a long text string instead of formated text. Are there any other approaches of doing it?

For formatting i am using CKeditor library.

Maybe there are easier ways of doing it?

Ravi Gadag · Accepted Answer · 2012-02-11 20:06:08Z

1

if i am not wrong you can use html.raw helper to get the string in html . then store it in database. but using html.Raw, it will lead to security loops. user may do XSS attacks. you can use @Html.Raw(), with AntiForgeryTokens.

var someText = "<b>Hello World</b> blahblah"; 
@Html.Raw(someText);

Html.Raw() , Html.AntiForgeryToken

answered Feb 11, 2012 at 20:06

Ravi Gadag

15.9k5 gold badges60 silver badges85 bronze badges

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

2 Comments

Timsen Over a year ago

is it smart to save it to Varchar in DB? or should i use something else?

Ravi Gadag Over a year ago

it will return as HtmlString. so you need to assign HtmlString to your POCO objects

Collectives™ on Stack Overflow

Save formated text from MVC 3 app to MSSQL Database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related