Displaying text in Data Grids as entered...

[Goldberg]

Right quick one for you all (hopefully.....)

I've got my Fantasy Footy site done in asp.net (vb.net code behind).

One of the features is a 'mini message board' where me and the guys have some banter. The user enters the code via a multi line text box. This is then written to a Char type field in the SQL database (i'm sure it's char, if not it's text.). When I look at the entry in the SQL database I see it how it was typed eg:
'Hello
This is a post in Goldy's message board for his football site.
Wow! isn't he good!'

However when I call the entry back to be displayed in a Datagrid I get the following returned:
'Hello This is a post in Goldy's message board for his football site. Wow! isn't he good!'

As you can see I am missing the carrige returns..... The only way around this is to actually input HTML tags when creating the message such as

<p>, <br> etc...

.

I am sure this is just some sort of formatting issue?

I have another problem with binding data to a label, but i'll sort this one first

[shadowdancer]

you'd need to do a replace on vbcrlf with the < br > to show the carriage returns correctly.

ie

newtext = replace(originatext,constants.vbcrlf,"<br>")

[Goldberg]

Cheers will give it a go.

Right next question:

I am trying to display the contents of an SQL record to a label. I am using the databind procedure bowever all i ever get is SQL.COMMAND.DATABIND or something similar in the label? (I can get the code tonight for tomorrow)

[debug77]

Have you set the DataField property on the label?

[Goldberg]

Yeah debug i'm sure I have. I'm using the Webmatrix GUI, also searching through my Many asp.net book but it doesn't seem to help. Sorrybut forgot the code as I was playing resi-evil 4 all night lol. i'll look tonight and also try the other tip for the text in the datagrids.

[Goldberg]

you'd need to do a replace on vbcrlf with the < br > to show the carriage returns correctly.

ie

newtext = replace(originatext,constants.vbcrlf,"<br>")

Tried this last night and works a treat , it's a lot easier than my previous solution which was a lot longer than 1 line lol.