Comments on: Converting SQL Server newline character to HTML break

By: Harpreet Singh

Harpreet Singh — Thu, 05 Aug 2010 21:36:53 +0000

this is the best post on this issue. I was looking for hours for this solution but never thing of using regular expression.

Good work. Keep it up

admin — Tue, 30 Mar 2010 16:46:45 +0000

Thank you for feedback! I updated the post

Boaz — Wed, 17 Mar 2010 22:13:27 +0000

looks like the html text did not make it…like the break tag in the regEx.Replace statement…
It should have been there after the ” “body”), ”

you get the idea…

Boaz — Wed, 17 Mar 2010 22:10:38 +0000

Good post. While building a commenting feature for a website I’m working on, I needed to convert “\n” to as well.

I found another way to do this.
Here’s what I did – it is in C#:

I am using a repeater control which displays the comments.
In my page class, I created a RegEx variable like so:

protected static Regex regEx = new Regex(“\n”);

protected void Page_Load(object sender, EventArgs e)
{
…
}

Then, within my repeater control’s section, I included this:

<%# regEx.Replace((string)DataBinder.Eval(Container.DataItem, "body"), "”) %>

“body” is the column name returned by my database procedure for the comment text.

Both ways seem to work fine.
My way has less code, though.

Thanks for the post!