How to display new line?

[hoobas20]

Hello guys! I am new in ASP.NET and Oracle database.. I just wonder on how to display new line from browser? I use multi-line textbox control to place all comments of the user. The user wants to see all new lines from the browser after clicking the print button. By the way, i user literal control to display the records accordingly. I tried creating a function that replaces all "\n" to "<br>"

Here's my code :

public function RecognizeNewLines(byVal myString as String) as String
Dim newString as String = String.Empty
newString = myString.Replace("\n", "<br>")
return newString

Am I missing something ? I dont know how to capture new lines in oracle . Is this the proper way to solve this issue?

Thanks guys

[mendhak]

It won't necessarily be \n. It may be \r\n as I've seen quite commonly in a few DBMSs. You could also try looking for System.Environment.Newline in myString and replacing with <br />.

[hoobas20]

Thanks for the reply. I tried looking on how oracle represents new line in database but unfortunately I didn't see any "\n" or "\r" in the database.. Does oracle have different representation for new line ? If so, what is it? Thanks guys!

[mendhak]

OK, what do you get in the debugger visualizers (tooltips) when you retrieve the data from Oracle?

So what I'm asking you to try is to retrieve some data from your Oracle table that you know contains a line break, then set a breakpoint on that line. When it's hit, mouseover or quickwatch the (for example) datarow and look at how the newline is represented.

[brin351]

I think string.replace("\n" .... will actually look for the characters "\n" not a line feed.

if you try regex \n & \r should work like regex.replace(myString, "\n", "<br>")