Hi,

Any sample code to show how to have master and details BOs shown in XtraGrid (in same grid)?



Thank you

Hi,

Thank you for sample.

I have tried it, but VS keep complaining it is not typed dataset. (I attached the code)

I also tried to add your sample project to my solution, and add to my form (difference project). VS unable to locate the sample dataset while trying to add item to toolbox.



Any ideas?



Thank you

Chan,

The project doesn't have the business objects that you are using in the dataset so I can't easily see what the issue is.

Are you saying the dataset does not show up on your toolbox?

Here are the steps that should make this work

Create a class that inherits from datasetbase

drop business objects on the new class

override relations if needed

Rebuild solution

should have new class in toolbox,

drag new class onto form or report from toolbox and set data source and member

hi,

I have reattach another sample.



Thank you.

ok i'll try to take a look at it

Paul's example and description of how to use a multi-detail band on any environment relying on the IList interface is very good.  It thought I would also share what we do.  We take a slightly different approach and this is how we create our strong-typed data sources for reporting and grids.

Let's take the report approach as this will be what I believe everyone is trying to accomplish here.  We have a reporting assembly that has a data source for each report that we create.  Our base data source inherits off of the BusinessBindingSource, we also inherit the BO we plan to use off of the primary BO so that we can add any custom fields without making a mess of the original BO.

Trent,

Does that allow you to do master detail binding?

In other words

Customer-->

                  Orders-->

                                 Order Items

Yes, you can chanin these together.  So you may have a CustomersBBS and a CustomerOrdersBBS.  Within the CustomersBBS you can create a property that exposes the CustomerOrdersBBS.  There are two hitches that you have to account for.  First, the private field that exposes the child needs to be shared and second, you have to manually filter out the child records when returning the child object.

This is what we do for all of our reporting and have some very deep and complex relationships and it has worked out great!

Trent,

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 will see if I can't get a sample created for the next build so that it is a bit more in-depth.  This is the approach that we use and it has worked well.

Peter,

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 .

Paul

Hi,

After created BBS, how to set it to xtragrid to show master details?



Thank you

Hi,

I finally able to make xtragrid recognize my dataset and relations of my dataset. However, when I set datamember of gridview, it prompted error 'child list can not be created'



Any ideas?



Thank you

Is there an InnerException to that exception?  It might give you more info as to why it was unable to create the list.

Hi,

I still failed to configure xtragrid to show "+" sign using BBS as suggested. What should I set so that xtragrid grid know it is master and details?



In my previous post, I mentioned IO able to configure xtragrid, is using DataSetBase provided by Paul Chase. Sorry for confusing.

Chan the inner exception still would be helpful to see what is going on, I never had any errors like the the one you describe so am not sure what would cause it

I know you converted the code I did into C# so maybe something got messed up in the conversion?

The samples you sent earlier are not very helpful to me, can you try to replicate the project I created in VB using the strataframe sample database?

Paul