Advice to connect 2 datagrids

Hi,
I created an application with radzen.blazor to make a CRUD.
I have set up a local database to store the data.
I would like to create a new datagrid to make a synthesis of my database. I need to communicate with the database, I think I use LINQ and transfer the results to my synthesis datagrid.

I don't hide you that I have difficulties to implement all this.

Would you have some examples to propose to me?

The radzendatagrid (named Developer) looks like this :

the radzendatagrid (named synthesis) loks like this :

With the datagrid synthesis I want to plot the bar chart.

You have understood I can't make the link between the two datagrid.
I know it's not a problem with radzen but rather a lack of knowledge in c#. I hope you can help me. Thanks in advance.

Hi @Sbl

Perhaps the master detail demo would give you a hint how to implement your requirements Free Blazor Components | 60+ controls by Radzen

Hi, Indeed it can help me!
I have a question about the master detail
I've checked on github the RadzenBlazorDemo : here https://github.com/radzenhq/radzen-blazor/tree/master/RadzenBlazorDemos
I don't really understand one thing. In order tab you fill the column Quantity wit only the line code :

<RadzenDataGridColumn TItem="OrderDetail" Property="Quantity" Title="Quantity" />

How do you fill this column?
I checked in the orderdetail class that there was no value or calculation of the quantity.

Thanks in advance

The Quantity property comes from a column in the database.

I was quite sure that it was in the base.
I would like to do synthesis of the database in tab (e.g sysnthesis).
I tried to do like your example but it does not work.