Binding DataGrid with Multiple collections

[Nikhil Jain]

Hi

I Want to know how can I bind a single DataGrid with Multiple ObervableCollections with each ObervableCollection having different element Type.

Regards
.

[Ivan]

Can we get some sort of answer to this question?

Im having a similiar issue. Here is an example scenario:

I have two database tables, Product and orders. I can easily use a linq query to return the Product table into an observable collection, then bind that to the radgrid. But i want to go further, and join the product and orders table together (join them on the primary and foreign keys) and bind that to the radgrid. This now means im trying to bind the grid to two types (product and orders).  Any help or a code example on how to go about this maintaining mvvm rules. Thanks,

[Ivan Ivanov]

Hi Ivan,

Please, refer to the attached example and let us know if this approach meets your requirements.

All the best,
Ivan Ivanov
the Telerik team

[Ivan]

Thats an excellant example thankyou.

Now, in your example you bind to the query using the itemsource in the code behind file.
What I tried doing however was setting the binding in the xaml file because I want to minimise code in the code behind file.
I managed to do this. But of course now im binding to a method in my ViewModel which requires some sort of return type. This is when I get confused again. So how do we do this? Do I have to make my query output to a observable collection? When I try this I get lots problem, because my collection or list is for only 1 type which is either products or orders. Can you help me with this scenario?


So basically can you modify the example solution that shows binding in the xaml instead of the code behind file?

Thanks, Ivan.

[Ivan Ivanov]

Hi Ivan,

I have prepared a MVVM implementation of my initial project. Please, refer to it.

All the best,
Ivan Ivanov
the Telerik team