I want to display on a gridview data from a table A with cardinality 1-N with several tables (B,C,D, E ..) . I want to display all table data (A,B,C,D, E ..) with a condition : to have exactly one line for each data from table A. the data from tables B, C, D … I want to display them as many columns, and iterate as long as I have data.
How can I achieve this? I thought of Pivotgrid but that does not answer exactly what I ask?
Please fined in attach what’s the grid should look like.
PS: i need also to export the Grid in an Excel file .
Thank you .