Data grid from dynamic SQL query

Radzen.Blazor Components
1

Hi,

Is it possible to get a data for data grid from dynamic sql query? I mean that for the same data grid in the same page the data and schema will change according to the result of a dinamic query (like list of queries and when the user select a query he will see the data from this query in the data grid).
The names and types of the columns can be different from one query to another.

Thanks,
Dvir

2

This demo might help you:

3

Thanks, I will try.
Can I use sql server Stored Procedure from my DB to apply all the CRUD functionality?

4

CRUD is performed on events: button clicks, form submits, etc. - you can use whatever serve your needs.