I have a bound field in a DetailsView control that displays free form
description type data from my SQL database table (typical data is a
couple of paragraphs of written product description being held in a
single database field of type ntext).

This description data typically has various simple control characters
in it - ie. new line, carriage returns etc) to make the paragraph more
readable.

My problem is that these control characters are lost / don't work....
When I run the application all text in the field displays as a simple
lump of text.. without any new lines etc.

Below is the simple definition I am using inside the DetailsView..

<asp:BoundField DataField="Description" HeaderText="Description"
SortExpression="Description" />

Can anyone suggest a solution ?

Thanks,
Bazza

On Aug 1, 10:57 pm, Bazza Formez  wrote:

> I have a bound field in a DetailsView control that displays free form
> description type data from my SQL database table (typical data is a
> couple of paragraphs of written product description being held in a
> single database field of type ntext).
>
> This description data typically has various simple control characters
> in it - ie. new line, carriage returns etc) to make the paragraph more
> readable.
>
> My problem is that these control characters are lost / don't work....
> When I run the application all text in the field displays as a simple
> lump of text.. without any new lines etc.
>
> Below is the simple definition I am using inside the DetailsView..
>
> <asp:BoundField DataField="Description" HeaderText="Description"
> SortExpression="Description" />
>


instead of BoundField use a TemplateField

<asp:TemplateField>
<ItemTemplate>
<%# Replace(Container.DataItem("Description"), vbCrLf, "<br>") %>
</ItemTemplate>
</asp:TemplateField>

and in C# use

Replace("\n", "<br>");

On Aug 2, 9:24 am, Alexey Smirnov  wrote:

> On Aug 1, 10:57 pm,BazzaFormez wrote:
>
>
>
>
>
> > I have a bound field in a DetailsView control that displays free form
> > description type data from my SQL database table (typical data is a
> > couple of paragraphs of written product description being held in a
> > single database field of type ntext).
>
> > This description data typically has various simple control characters
> > in it - ie. new line, carriage returns etc) to make the paragraph more
> > readable.
>
> > My problem is that these control characters are lost / don't work....
> > When I run the application all text in the field displays as a simple
> > lump of text.. without any new lines etc.
>
> > Below is the simple definition I am using inside the DetailsView..
>
> > <asp:BoundField DataField="Description" HeaderText="Description"
> > SortExpression="Description" />
>
> instead of BoundField use a TemplateField
>
> <asp:TemplateField>
> <ItemTemplate>
> <%# Replace(Container.DataItem("Description"), vbCrLf, "<br>") %>
> </ItemTemplate>
> </asp:TemplateField>
>
> and in C# use
>
> Replace("\n", "<br>");- Hide quoted text -
>
> - Show quoted text -


Thank you very much Alexey!