I was wonder if someone could tell me how to include the formating of a 
textbox when stored in a database.

I have a multiline textbox in which the user places information.  I then 
store this in my database and retrieve it for viewing in a datagrid on 
another page.  However the carriage returns entered in the textbox are 
lost when displaying in the datagrid.

Any assistance would be greatly appreciated.


Thanks


Warren

The soft carriage returns are not included in the text.  You must preserve
the width of the text field manually.
However, if you use the enter key to record a crlf then that hard coded
return will be saved with the text.  This is the same behavior as vb6 has.

----- Original Message -----
From: "Warren Nielsen" <warren.nielsen@a...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Wednesday, April 24, 2002 12:46 AM
Subject: [ado_dotnet] MultiLineTextbox


> I was wonder if someone could tell me how to include the formating of a
> textbox when stored in a database.
>
> I have a multiline textbox in which the user places information.  I then
> store this in my database and retrieve it for viewing in a datagrid on
> another page.  However the carriage returns entered in the textbox are
> lost when displaying in the datagrid.
>
> Any assistance would be greatly appreciated.
>
>
> Thanks
>
>
> Warren

> The soft carriage returns are not included in the text.  You must 
preserve
the width of the text field manually.
However, if you use the enter key to record a crlf then that hard coded
return will be saved with the text.  This is the same behavior as vb6 has.

----- Original Message -----
From: "Warren Nielsen" <warren.nielsen@a...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Wednesday, April 24, 2002 12:46 AM
Subject: [ado_dotnet] MultiLineTextbox


> I was wonder if someone could tell me how to include the formating of a
> textbox when stored in a database.
>
> I have a multiline textbox in which the user places information.  I then
> store this in my database and retrieve it for viewing in a datagrid on
> another page.  However the carriage returns entered in the textbox are
> lost when displaying in the datagrid.
>
> Any assistance would be greatly appreciated.
>
>
> Thanks
>
>
> Warren

Firstly thank you for your response.  however could you please provide an 
example of how to recognise the CRLF and replace with <BR>.  I would be 
greatly appreciative.

Thanks

Warren