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
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" …