«

Hello - I'm displaying a SQL Server text field in a bound column. The text
field has line breaks (CrLf - 0D0A) but the text displays in a long string in
the DataGrid. Anybody know how to display them?
--
Rosko

Sorry...forgot to mention this is ASP.NET on our intranet.
--
Rosko


"Rosko" wrote:

> Hello - I'm displaying a SQL Server text field in a bound column. The text
> field has line breaks (CrLf - 0D0A) but the text displays in a long string in
> the DataGrid. Anybody know how to display them?
> --
> Rosko

Rosko,

Use a databinding expression that replaces the occurrences of
Environment.NewLine with "<br/>" as I did in this demo:
http://www.societopia.net/Samples/Da...Hierarchy.aspx

--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com


"Rosko" wrote:

> Sorry...forgot to mention this is ASP.NET on our intranet.
> --
> Rosko
>
>
> "Rosko" wrote:
>
> > Hello - I'm displaying a SQL Server text field in a bound column. The text
> > field has line breaks (CrLf - 0D0A) but the text displays in a long string in
> > the DataGrid. Anybody know how to display them?
> > --
> > Rosko

Works great. So simple, so elusive. Thanks so much for your help!
--
Rosko


"Phillip Williams" wrote:

> Rosko,
>
> Use a databinding expression that replaces the occurrences of
> Environment.NewLine with "<br/>" as I did in this demo:
> http://www.societopia.net/Samples/Da...Hierarchy.aspx
>
> --
> HTH,
> Phillip Williams
> http://www.societopia.net
> http://www.webswapp.com
>
>
> "Rosko" wrote:
>
> > Sorry...forgot to mention this is ASP.NET on our intranet.
> > --
> > Rosko
> >
> >
> > "Rosko" wrote:
> >
> > > Hello - I'm displaying a SQL Server text field in a bound column. The text
> > > field has line breaks (CrLf - 0D0A) but the text displays in a long string in
> > > the DataGrid. Anybody know how to display them?
> > > --
> > > Rosko

You are quite welcome.
--
HTH,
Phillip Williams
http://www.societopia.net
http://www.webswapp.com


"Rosko" wrote:

> Works great. So simple, so elusive. Thanks so much for your help!
> --
> Rosko
>
>
> "Phillip Williams" wrote:
>
> > Rosko,
> >
> > Use a databinding expression that replaces the occurrences of
> > Environment.NewLine with "<br/>" as I did in this demo:
> > http://www.societopia.net/Samples/Da...Hierarchy.aspx
> >
> > --
> > HTH,
> > Phillip Williams
> > http://www.societopia.net
> > http://www.webswapp.com
> >
> >
> > "Rosko" wrote:
> >
> > > Sorry...forgot to mention this is ASP.NET on our intranet.
> > > --
> > > Rosko
> > >
> > >
> > > "Rosko" wrote:
> > >
> > > > Hello - I'm displaying a SQL Server text field in a bound column. The text
> > > > field has line breaks (CrLf - 0D0A) but the text displays in a long string in
> > > > the DataGrid. Anybody know how to display them?
> > > > --
> > > > Rosko

[mohanms]

hi guys.
its not workin for me...
im using Ajax grid. but the methods r almost the same. im jut bindin the data from the front end insead of the backend. the rest should be similar.

when i used the methods suggested, "<br/ >". its displayin the <br/ > instead of movin to newline. any help? thanks

[CraigPaardekooper]

So you want to add line breaks to a datagrid, and you are using bound columns.

You can achieve this as follows -

1. When you insert text into your database use - replace(vbcrlf, "<br>")

2. When you click on the Edit button (ie the datagrid_editcommand) column then use - replace("<br", vbcrlf) . The way I do this is I create a Method and call it immediately after the databinding event.



ProtectedSub GridView1_EditCommand(ByVal source AsObject, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles GridView1.EditCommand

GridView1.EditItemIndex = e.Item.ItemIndexDim ds AsDataSet = GetDataset()

BindGrid(ds)

AddLineBreaks()
EndSub


The AddLineBreaks Method loops through all the rows of the datagrid, and when I find the row that is in EditMode, then I can replace the "<br>" in that row with vbcrlf

Sub AddLineBreaks()

For i = 0 To GridView1.Items.Count - 1

If GridView1.Items(i).ItemType = ListItemType.EditItem Then

CType(GridView1.Items(i).Cells(1).Controls(0), TextBox).TextMode = TextBoxMode.MultiLine

CType(GridView1.Items(i).Cells(1).Controls(0), TextBox).Width = System.Web.UI.WebControls.Unit.Pixel(400)

CType(GridView1.Items(i).Cells(1).Controls(0), TextBox).Height = System.Web.UI.WebControls.Unit.Pixel(100)

CType(GridView1.Items(i).Cells(1).Controls(0), TextBox).Text = CType(GridView1.Items(i).Cells(1).Controls(0), TextBox).Text.Replace("<br>", vbCrLf)

EndIf

Next

Note that this will also allow you to resize the textboxes during edit mode for a datagrid

The Items collection of a datagrid are it's rows, and each row contains a collection of Cells, and each cell conatins a collection of controls. So you can speify which cells you want to replace <br> with vbcrlf, and which textboxes you want to resize.

3. When you click on the update button then use - replace(vbcrlf, "<br") . The update button in a datagrid triggers the update_command event. This will read the contents of a textbox while in edit mode, and replace vbcrlf with <br>

YOURCOLUMNNAME =
CType(e.Item.Cells(1).Controls(0), TextBox).Text.Replace(vbCrLf, "<br>")

I hope this helps datagrid people with both line breaks and with resizing editmode textboxes.