Dynamic SQL in datagrid

[kgordon]

I have a stored procedure which returns a dataset, however, this dataset is dynamic because I'm using a pivot table to produce dynamic columns. So two questions:

1. Is there a way I can add this to a datagrid dynamically so that all the columns returned in the dataset get automatically shown in the datagrid or
2. Is there a way to handle pivot tables inside Radzen so I don't have to rely on SQL Server which is a pain to setup on it's own

[joshbooker]

You could try the syncfusion pivot table component https://www.syncfusion.com/blazor-components/blazor-pivot-table

[iAmBipinPaul]

Hi , As mentation here , you can achieve this in this way.
It's mentation here that sorting and filtering does not work but works in my case.
(sorting works out of the box for filtering we are using <FilterTemplate>)

Use RadzenGrid to display a dynamic table

Hi, I try to use a RadzenGrid to display a dynamic table. The columns of the table are configured in a JSON file, so I don't know in advance what they will be. I am using a List < ExpandoObject > to get the data and can successfully display it but sorting and filtering doesn't work as the underlying code seems to be unable to access the dynamics members in my ExpandoObject. My grid looks like this: <RadzenGrid AllowFiltering="true" FilterCaseSensitivity="FilterCaseSensitivity.CaseInsensitive" …