Dynamic SQL in datagrid

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