asp.net saving string to SQL including line breaks for formating

Question

I want to be able to store strings in the DB but some are long and i want to format them such that when i copy them out of SQL and past them into notepad they have line breaks to break up the otherwise single line that runs on forever and hard to read.

lets say i am storing a string of all the session variables like this, how do i include line breaks in here?

StringBuilder theBody = new StringBuilder();

theBody.Append("Session Values: " + "\n");
foreach (string s in Session.Keys)
theBody.Append(s + ":" + Session[s] + "\n");

How are you writing strings to SQL now?

n8wrl
– n8wrl

2011-02-10 18:04:45 +00:00
Commented Feb 10, 2011 at 18:04 — n8wrl
– n8wrl, Commented Feb 10, 2011 at 18:04

Filip Ekberg · Accepted Answer · 2011-02-10 18:02:44Z

1

You might want to consider changing those "\n" to System.Enviornment.NewLine instead. And also, you can use AppendLine instead of Append.

answered Feb 10, 2011 at 18:02

Filip Ekberg

36.3k20 gold badges129 silver badges184 bronze badges

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

Collectives™ on Stack Overflow

asp.net saving string to SQL including line breaks for formating

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