Display multiple row values into single cell (LINQ and RadGrid)

[Brian Flaherty]

Below is a scaled down version for what I am needing.

Table A has two columns:  Location_ Name,  ITEM_ID
Table B has two columns:  ID,    Description

Relationship is 1 to many, respectively.

In my grid I want to concatenate all descriptions delimited by ',' and by each location into a single cell.

The output would be as follows:

Location                                         Description

Westchester                12546,145879,15698,12583
Torrance                     32145,3258,32458
Glendale                      14785
Pasadena                    14589,156478


Grid properties:

AutoGenerateColumns

 

 

="False"
AllowFilteringByColumn="True"

 

 

 

AllowPaging="True"
AllowSorting="True"


Please advise how I can achieve this?

Thanks in advance.

 

[Yavor]

Hi Brian,

The following example demonstrates how to nest additional information in a template column:

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/columntypes/defaultcs.aspx

You can concatenate the two tables either dynamically from the code behind, into one table, or via the select statement of the datasource control, by joining them.
I hope this information gets you started properly.

Best wishes,
Yavor
the Telerik team

[Mark]

Link no longer works
: (

[Pavlina]

Hi Mark,

The demo link opens as expected. Can you try opening it again and see if you still encounter the same problem?

Kind regards,
Pavlina
the Telerik team

[Chandan]

You can try this:

 <telerik:GridCalculatedColumn

DataFields="QUESTION,OPT_1,OPT_2,OPT_3,OPT_4"

FilterControlAltText="Filter QUESTION column"

HeaderText="Question & Options"

Expression='"<strong>Question:</strong> " + {0} + "<br/><br/> <strong>Option 1: </strong>" +  {1} + "<br/> <strong>Option 2:</strong> " + {2} + "<br/> <strong>Option 3:</strong> " + {3} + "<br/> <strong>Option 4:</strong> " + {4} + "<br/>" '

UniqueName="QUESTION">
                                          
</telerik:GridCalculatedColumn>​