Radgridview cannot edit column when binding from pivot tabel datasource

[andi]

I have radgridview with 3 level hierarchy, the third hierarchy binding from query using pivot table, data are appear in grid well but cannot edit column generate from query with pivot table, so how to make it editable?

Thanks in advanced

[Hristo]

Hello Andi,

A possible cause of the issue might be that you are binding the grid to anonymous types. I am not sure what is your query and what data it returns for the third level but if you are using LINQ and returning objects with select new the grid will bind to these objects but you will not be able to edit them. This behavior can also be observed with the standard .NET grid control. The following articles provide more information on that matter: 

• https://stackoverflow.com/questions/3474531/linq-and-how-to-return-a-list-of-a-specific-type
• https://stackoverflow.com/questions/4004311/unable-to-edit-any-columns-in-my-c-sharp-datagridview-would-anyone-know-why

In case you keep experiencing the issue, please open up a support ticket and send us your project.

Regards,
Hristo
Progress Telerik