Getting results as DataTable

[David]

I have a DataTable that is the source for my DataFilter but I need to get the FilteredSource as a DataTable back out. Is there an easy way to accomplish this using the current control?

Thanks,
Shawn

[Vlad]

Hello,

 Can you clarify why you need this?

Regards,
Vlad
the Telerik team

[David]

We have an existing set of code that utilizes the Telerik ORM to create a DataTable from an open-ended database structure. Due to the dynamic nature of the data being pulled/created, Telerik recommended this approach. We have now written code that generates a report based on the DataTable structure but our customer has requested the ability to filter certain parts of the results from the UI.

In playing around with the DataFilter, we found it could easily answer this as it can filter the DataTable results without a problem but the output was in a ItemDataCollection format which is not compatible with the other code that already exists. Since the report generation code is complex and our time is short for delivery, it is not something we ideally want to rewrite.

I wanted to know if there is a simple way to convert the ItemDataCollection to a DataTable.

[Vlad]

Hi,

 You can use the approach from this thread:
http://stackoverflow.com/questions/1253725/convert-ienumerable-to-datatable

Best wishes,
Vlad
the Telerik team

[David]

Thanks. That code example worked for me.