simple one..... from HTML to SQL to HTML... i lose my new lines

[Justin Rich]

Im not sure where i lose the new line stuff but when i pull it back from the
DB its gone.

Im using the SQLDataSource control. i pull it and push to a asp:textbox.

i assume there is something simple i need to do?

[Aaron Corcoran]

Justin,

I believe that a simple replace statement should solve your problems.
If I am not mistaken, it is stored in SQL as Chr(13). You should be
able to do a replace command and replace the Chr(13) with a <BR> tag.

Let me know if this helps. I know the following is what is used when a
datagrid is populated:

<asp:TemplateColumn HeaderText="myField" Visible="True">
<ItemTemplate>
<%# myDataSet.FieldValue("myField", Container).
Replace(Chr(13), "<br>") %>
</ItemTemplate>
</asp:TemplateColumn>

Aaron

[Justin Rich]

FieldValue is not part of a SQLDataSource.
also what namespace is the Chr function in?

Thanks
Justin

"Aaron Corcoran" <ac*******@lasers.state.la.us> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Justin,

I believe that a simple replace statement should solve your problems.
If I am not mistaken, it is stored in SQL as Chr(13). You should be
able to do a replace command and replace the Chr(13) with a <BR> tag.

Let me know if this helps. I know the following is what is used when a
datagrid is populated:

<asp:TemplateColumn HeaderText="myField" Visible="True">
<ItemTemplate>
<%# myDataSet.FieldValue("myField", Container).
Replace(Chr(13), "<br>") %>
</ItemTemplate>
</asp:TemplateColumn>

Aaron