Grid: Generate Grid from a SQL-Query

1 Answer 48 Views
Grid
Hendrik
Top achievements
Rank 2
Bronze
Iron
Iron
Hendrik asked on 11 Oct 2024, 06:05 AM
I would like to display the result of a dynamic SQL query, which therefore cannot be typed, in a grid. I tried it with AutoGenerateColumns=“true”, but it didn't work. I load my data into an IEnumerable<dynamic>. Is there a solution for this ?

1 Answer, 1 is accepted

Sort by
0
Dimo
Telerik team
answered on 15 Oct 2024, 06:28 AM

Hi Hendrik,

Binding the Grid to dynamic data is possible, but with some restrictions and caveats. For example, AutoGenerateColumns cannot be used. Please refer to:

Grid Data Binding Scenarios - check the bullet about DataTable and ExpandoObject

Regards,
Dimo
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Grid
Asked by
Hendrik
Top achievements
Rank 2
Bronze
Iron
Iron
Answers by
Dimo
Telerik team
Share this question
or