Problem with multiple lines in db data

[Loading name...]

hey

asp.net 2.0

In my db (sql server 2005) I have a record which consist of multiple lines:
"HEY
THIS IS A TEST
OF MULTIPLE
LINES"

But when I retrieve this value and put it into a formview field, the data is
displayed like this:
"HEY THIS IS A TEST OF MULTIPLE LINES"

Some of the settings on the textbox displaying the datafield on one row (I
want it to display multiple lines)
<asp:TextBox TextMode="MultiLine" ID="jalla" runat="server"... >
</asp:TextBox>

Any suggestions to what I should do to get this datafield displaying the
original text (multiple lines)?

[John Timney \(MVP\)]

When you set the TextMode attribute to "Mulitline", the control will render
as an HTML TextArea. Your text has to be html compliant to display on
multiple lines so you need to take a look at the output and see whats being
displayed. Sometimes, replacing carriage returns with <bror wrapping the
whole section in <pretags may be necessary but it all depends on what went
into your database in the first place.

Regards

John Timney (MVP)
"Loading name..." <it_consultant1@NO_SPAM.hotmail.comwrote in message
news:uN**************@TK2MSFTNGP04.phx.gbl...

hey

asp.net 2.0

In my db (sql server 2005) I have a record which consist of multiple
lines:
"HEY
THIS IS A TEST
OF MULTIPLE
LINES"

But when I retrieve this value and put it into a formview field, the data
is displayed like this:
"HEY THIS IS A TEST OF MULTIPLE LINES"

Some of the settings on the textbox displaying the datafield on one row (I
want it to display multiple lines)
<asp:TextBox TextMode="MultiLine" ID="jalla" runat="server"... >
</asp:TextBox>

Any suggestions to what I should do to get this datafield displaying the
original text (multiple lines)?