line break in a datagrid

[hannes]

hello to all,

how to get an line break from a database to the datagrid?

thanks,
hannes

 

[Riki]

hello to all,

how to get an line break from a database to the datagrid?

thanks,
hannes

You didn't say in which language. I'm using VB.NET here.

Turn AutoGenerateColumns off. Add BoundColumns instead.
For the column that has line breaks, convert the BoundColumn
to a TemplateColumn.
In the TemplateColumn replace
<%# DataBinder.Eval(Container.DataItem,"myField") %>
with
<%#
DataBinder.Eval(Container.DataItem,"myField").ToString().Replace("vbCRLF","<br>")
%>