>A have a field in one of my database tables that contains text with carriage returns. I need to bind this (read only) to a UI control to show these comments to the user on the page. What control or technique should I use? I tried < asp:TextBox > with a wide width and tall height, but it does honor the carriage returns.
>
>The text in the table field is like this:
>
>1. Information / Comment number one will go here.
>2. Then, Information / Comment number two will go here.
>3. And, Again, Information / Comment number three will go here.
>4. And so on...
>
>I manually edit this data as an admin when I add the record, then I need to show it like plain text on a page when the user is viewing the record.
>
>Also, what is the proper data type to make this field in the table? Right now it is a type called "ntext", and I'm not even sure why it is that type. This data was given to me by the customer in Access, and I upsized it into SQL Server. I can change the type however I need to, so what is best for this case?
I would suggest using varchar(max) for the data (varchar if you don't expect unicode characters and nvarchar if you do).
You may try to replace all Environment.NewLine characters with
<br/><br/>
and assign the text to label control. I think I asked a similar question before with this kind of suggestion by Paul M - I'll search here.
If it's not broken, fix it until it is.
My Blog