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