DataFormatString Question with "RETURNS" in Data Type

[Phillip Vong]

VS2005 on a SQL 2000
Please help me understand how to fix this problem.

In SQL, a column is assigned Data Type of nvarchar(250). In each row, the
value looks like this.
FirstName LastName "SQARE BOX" a12720 "SQUARE BOX" 14 Meadow Road

The "SqareBox" shapes are Returns from the keyboard.

When I'm doing a Details View, all this information runs together with just
spaces where the SQUARE BOXES are. Is there some kind of formating in VS2005
setting to tell it to recognize them as RETURNS so it will display properly?

Thanks in advance.

Phil

 

[neilmcguigan]

either put the content in a <pre></pre> tag

or replace the carriage return/line feeds with a <br /> tag, like this:

myString.Replace("\r\n", "<br />")

cheers

neil

 

[Phillip Vong]

Please forgive me for sounding stupid, but I'm a newbie. Where do I put
this code? Do I put this as in an event handler? If so, which one?

The data is in DetailsView1 and bound to AddText.

What do I do with this code?

Thanks!