Multiple lines in a RadGrid cell?

[John]

Hi all:

I ahve data that is being displayed in a RadGrid, and some of the data has multiple lines per row. So for example it might be

Col 1     Col 2      Col 3
Row 1   Test 1     1
                            2
                            3
                           

and I need to replicate this display in the RadGrid cell. I tried to build a string thus:

string strRates = 1 + "\r\n" +
                           2 + "\r\n" +
                           3 + "\r\n";

and then display that string in the RadGrid cell, but the result ends up:

Col 1     Col 2       Col 3
Row 1   Test 1     1 2 3

Does anyone know if it is possible to display mutliple rows of data within 1 cell of the RadGrid?

John.

[Daniel]

Hello John,

Please try the following:

string strRates = 1 + "<br/>" +
         2 + "<br/>" +
         3 + "<br/>";

Regards,
Daniel
the Telerik team

[John]

Yes that worked, thanks!

John.

[Gabriele]

I have the same issue but the data I am using in the datagrid cell is coming from a database where the strings are stored using "\r\n". Once I bind the dataset to the datagrid the cvalues are automatically imported and the multiple lines are displayed as one line.

Any solution for this specific case?

Thanks.

[Daniel]

Hello Gabriele,

You can handle the ItemDataBound event and manually replace the \r\n character sequence with HTML line-break tags:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        TableCell myCell = (e.Item as GridDataItem)["MY_COLUMN_NAME"];
        myCell.Text = myCell.Text.Replace("\r\n", "<br/>");
    }
}

I hope this approach is suitable for you.

Regards,
Daniel
the Telerik team

[Parvez]

It works

thanks mate...

[Martin Roussel]

Hi, ive tried this method in order to multi-line my RadGrid with text data coming from my database, and it "works". Ive noticed however that grid data export (tried all formats) stop working when using this. Problem even occurs when no multi-line text exist. Since Admin's provided solution is kinda 'old', is there a better way?

UPDATE: it seems to affect GridTemplateColumn, which im using. It's seem to not affect GridBoundColumn. CSV export seem to be working.

TIA

Martin

[Daniel]

Hello Martin,

I just tried the same approach in a simple, runnable demo and it seems to work as expected. Please test the attached website and let me know if I'm missing something.

Kind regards,
Daniel
the Telerik team

[Martin Roussel]

Daniel,

I solved my issue by replacing my GridTemplateColumns by GridBoundColumns that seem to be more export-friendly (especially when the GridTemplateColumn contains more complex non-text controls).

Thanks anyway,

Martin