«

Hi all,
I try to save a multiline textbox into an sql field (nvarchar(1024)). As I
read it out and display, the text drops all the linefeed char.
Is there a way to cure this? Thank you all for help.

--Calsun

Not sure if u have alreday tried Server.HtmlEncode
http://www.devx.com/vb2themax/Tip/18542
http://msdn.microsoft.com/library/de...46ef320e78.asp

Thanks for the tips.
I tried it and it didn't work. I decoded before saving and encoded back, but
the linefeed char still missing.

Your help please. Thanks
--CS

<> wrote in message
news: oups.com...
> Not sure if u have alreday tried Server.HtmlEncode
> http://www.devx.com/vb2themax/Tip/18542
> http://msdn.microsoft.com/library/de...46ef320e78.asp
>

When you render the content, it renders it as HTML text. The problem is
that the browser ignores whitespace. Before rendering it, you will need to
change all linefeeds to <br>.

"CalSun" <> wrote in message
news:%...
> Hi all,
> I try to save a multiline textbox into an sql field (nvarchar(1024)). As I
> read it out and display, the text drops all the linefeed char.
> Is there a way to cure this? Thank you all for help.
>
> --Calsun
>

Thanks Peter,
I'll try that.
By the way, what is the value of the linefeed char inside a multiline
textbox?
thanks
--CS
"Peter Rilling" <> wrote in message
news:%...
> When you render the content, it renders it as HTML text. The problem is
> that the browser ignores whitespace. Before rendering it, you will need
> to change all linefeeds to <br>.
>
> "CalSun" <> wrote in message
> news:%...
>> Hi all,
>> I try to save a multiline textbox into an sql field (nvarchar(1024)). As
>> I read it out and display, the text drops all the linefeed char.
>> Is there a way to cure this? Thank you all for help.
>>
>> --Calsun
>>
>
>

Thank you all for helping.
I just converted ctrlf into <br> before saving. That works fine. However, it
won't look good if I query and display the text in a non-html environment.
--CS

"CalSun" <> wrote in message
news:%...
> Hi all,
> I try to save a multiline textbox into an sql field (nvarchar(1024)). As I
> read it out and display, the text drops all the linefeed char.
> Is there a way to cure this? Thank you all for help.
>
> --Calsun
>

When rendering in non-html just use the following concept to deal with the BR
tags:

// C# Code
string x = "some text<br>some more text<br>blah blah blah";
x = x.Replace("<br>", "\r\n");

' VB Code
Dim x as string = "some text<br>some more text<br>blah blah blah"
x = x.Replace("<br>", vbCrLf)



"CalSun" wrote:

> Thank you all for helping.
> I just converted ctrlf into <br> before saving. That works fine. However, it
> won't look good if I query and display the text in a non-html environment.
> --CS
>
> "CalSun" <> wrote in message
> news:%...
> > Hi all,
> > I try to save a multiline textbox into an sql field (nvarchar(1024)). As I
> > read it out and display, the text drops all the linefeed char.
> > Is there a way to cure this? Thank you all for help.
> >
> > --Calsun
> >
>
>
>