Private Shared _CustomerOrdersBBS As New CustomerOrdersBBS()
Public ReadOnly Property CustomerOrders Get '-- Filter out the child records _CustomerOrdersBBS.BusinessObject.Filter = "or_cust_pk=" & Me.BusinessObject.cust_pk.ToString()
'-- Return the filtered BO Return _CustomerOrdersBBS End GetEnd Property
End Class
This is what we do for all of our reporting and have some very deep and complex relationships and it has worked out great!
I got really busy yesterday so wasn't able to spend much time looking at this. Is there anyway you can create a sample of how to use the BBS to create a master detail grid?
I had some issues using the BBS as a binding source that was discussed in another thread. Ben gave me some good suggestions on how to get around the issues I faced but I ended up using this approach to grid binding as it meant I did not have to refactor and then retest quite a bit of logic.
Anyways it would be great to see an sample of how it would work using a BBS.
Paul
I got really busy yesterday so didn't have a chance to post this, this is an editable version of the data set class, basically what I am trying to do is to keep the business objects on the form in sync with the data tables in the data set.
For the most part I think it will work ok but there still may be some gotcha's I haven't ran across. I also threw in a report so you can see how that works.
Anyways I hope this helps out anyone that is looking to do this sort of thing.
I also am posting an infragistics 2007 volume1 version just cause it was easy enough to do .