Nullable decimal column empty in detail table

[Robert]

Hi,
I have a RadGrid with master table Orders and detail table OrderItems. OrdterItems table has nullable decimal column 'Price'.
When I expand detail table, Price column is empty, all other columns have values. Additionally, when I use the Price column in GridCalculatedColumn (e.g. Count * Price), I get an exception, that column [Price] was not found.

Columns in detail table are set declaratively. 

This happens only with OpenAccessDataSource, with SqlDataSource everything works fine.

Any solution?

Thanks,
Robert

[Veli]

Hello Robert,

Does your OpenAccess mapped entity object expose Price as a public field? You may want to check that. Also, try to bind the same OpenAccessDataSource to a regular ASP.NET GridView control and see if you can get the Price field showing. Chances are the Price field is not available as a property in the OrderItem entity at all.

Regards,
Veli
the Telerik team

[Robert]

Hello,

thanks for answer, I just found the reason why it happend. I didn't refresh my model and the property 'Price' was not present in OrderItem entity.

Best regards,
Robert