Hi!


I need to display long text field in the grid, the datatype in sql server is text. How should i display the data in this field and also give line breaks replaces enters in the field...

Inaddition i want to know which datatype is good to handle long texts like newses.

thanks,
erphan b rajput

Usually, I look for the Environment.Newline character within large text blocks, and replace them with "<br>".

I try to stay away from the Text datatype because it can be problematic. Seeing as SQL Server will support a Char data up to 8000 characters, I find that's usually sufficient for "long" text.