I have a client that is using an application which connects to an Access database. The application accepts input to a Memo field in the database which is preserving LF and CR characters. However, when the field is pulled into a gridview for display, the text is displaying as one blob; the LF and CR characters are ignored somehow.

Is there a property or method I should call when accessing the database so that this text field includes the formatting?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Either of these methods should work:

<databaseValue>.Replace(System.Environment.NewLine , "<br />");
<databaseValue>.Replace("\\r\\n", "<br />");

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Thank you! OK, so the database may realize what's going on, but it's literally passing the newline as characters and I have to manually convert that into an HTML element if I want the webpage to display properly.

Another question. The context makes sense in the string examples that I've been able to Google on the replace method, e.g. myString = myString.Replace(System.Environment.NewLine, "<br />");

But I'm a little less clear how this will work in my situation. I'm adding the field to the gridview as a bound field on the .aspx page.

e.g. <asp:BoundField DataField="DataEntry" HeaderText="Data" />

I'm assuming that I'll be using DataEntry.Replace(System.Environment.NewLine, "<br />"); somewhere in my code behind?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Since you are using a bound field, AFAIK, yes you will need to do this in your code behind before you bind the datasource to the control. If you were using DataBinder.Eval for example, you could add the Replace method directly inside of your gridview.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

I've decided to beat my head against this one again. I'm using...

protected void sdsDataEntry_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
DataEntry.Replace(System.Environment.NewLine, "<br />");
}

I've tried several different variations, but I keep getting errors when I try to compile that say "Data Entry" does not exist in the current context.

PS Don't I need to use the Selected, instead of the Selecting event? I wasn't certain and there's no "SqlDataSourceSelectedEventArgs" so I'm wondering if I'm not approaching that -- among other things ;) -- correctly.

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.