Dynamic SQL in datagrid

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

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

1 Like

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>)

1 Like