Have a form with

Two BO's (projectBO, subProjectBO)

Two  BusinessBindingSource's (projectBBS, subProjectBBS)

Two grids (projectDGV, subProjectDGV)

Have setup the ParentChild relationship as mentioned in the help but when I change rows in the parent grid (projectDGV) nothing seems to happen in the child grid (subProjectDGV) The Child grid always shows all rows. Have set the ChildAutoFilterOption to MatchCurrentRow on the Child BO

I call the FillAll() for both BO's in the Form's Constructor (after the InitializeComponent())

this.projectBO.FillAll();

this.subProjectBO.FillAll();

Have three questions:

1] What am I doing wrong?

2] Are all rows from the child table being retrieved and then filtered based on the Parent's key or only rows matching the Parent's Key being retrieved from the server?

3] How can I use SP's to retrieve data for the Parent and Child?

Thanks

Sarosh

Yes, by SP I meant Stored Procedure.

Thanks for the code that was exactly what I was looking for, just one more thing, what should the code look like for a child BO so that it retrieves only rows for the current Parent's Key rather than retrieving all rows and then they get filtered on the client side.

In other words how can I get the Parent's key from within the child BO so that I could then pass that to the SP which in turn would only retrieve the rows that matched the Parent's Key.

Thanks

Sarosh

Yes this helped a lot!

One thing I am still not clear about is if I have related the Parent-Child BO's and I don't write any other code then is the filtering happening on the client side? i.e. the Child's FillAll() is internally called which brings all rows from the child table and then those rows are filtered.

Sarosh