[Solved] Grouping on a DataTable

[Kevin]

Hi,

I am using Custom Server Binding to a DataTable containing results from a database query. I am trying to add grouping to the grid on a specific column but doing so gives me an exception:

[ArgumentException: Property with specified name: Row[ID] cannot be found on type: System.Data.DataRowView
Parameter name: propertyName]
   Telerik.Web.Mvc.Infrastructure.Implementation.Expressions.CustomTypeDescriptorExtensions.Property(ICustomTypeDescriptor typeDescriptor, String propertyName) +264
   lambda_method(Closure , DataRowView ) +44...

Code for the grid (where Model.Data is of type System.Data.DataTable):

Html.Telerik().Grid(Model.Data)
            .Name("Grid")
            .DataBinding(dataBinding => dataBinding.Server().Select("CustomServerBinding", "Grid")
            .Groupable(groupign => groupign.Groups(groups => groups.Add(o => o.Row["ID"])))

Query for the Data:

SELECT ID, Value, Credit FROM Report

Is there something that I am missing in my code?

Thank you,
Kevin

[Rosen]

Hi Kevin,

Unfortunately, with the current official version of our grid component there is no easy way to set initial group expression when bound to a DataTable. However, we have already addressed this limitation by adding the appropriate overloads (which accepts member name as string instead of as expression)
 to the GridGroupDescriptorFactory. Therefore, please download the latest internal build in which this functionality is available.

All the best,
Rosen
the Telerik team

[Kevin]

Hi Rosen,

Thank you for your reply. I have downloaded the latest internal build (1014) and it doesn't seem to be in there, is it in another build?

Thanks,
Kevin

[Rosen]

Hello Kevin,

Indeed, you are correct, the change in question is not available in the build you are referring to. However, I have attached a newer build which contains the required changes. Also those changes are also present in the Telerik Extensions for ASP.NET AJAX Q3 2011 BETA release.

Regards,
Rosen
the Telerik team

[Kevin]

Hi Rosen,

The hotfix worked, thanks!

Kevin