This is a migrated thread and some comments may be shown as answers.

Nullable decimal column empty in detail table

2 Answers 95 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Robert
Top achievements
Rank 2
Robert asked on 12 Aug 2010, 01:00 PM
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

2 Answers, 1 is accepted

Sort by
0
Veli
Telerik team
answered on 17 Aug 2010, 01:42 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Robert
Top achievements
Rank 2
answered on 17 Aug 2010, 01:45 PM
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
Tags
Grid
Asked by
Robert
Top achievements
Rank 2
Answers by
Veli
Telerik team
Robert
Top achievements
Rank 2
Share this question
or