StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Parent-Child in Grids

Parent-Child in Grids

Sarosh — Fri, 08 Jun 2007 22:42:49 GMT

Hi!

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

RE: Parent-Child in Grids

Trent L. Taylor — Fri, 08 Jun 2007 22:42:49 GMT

The child BO is not automatically populated, just filtered when using the auto filter settings. You still need to manually populate the child BOs records. There is actually not an intrinsic method called FillAll(), but rather FillByParentPrimaryKey and FillByParent which will both load the child records when you have the relationship setup.

RE: Parent-Child in Grids

Sarosh — Fri, 08 Jun 2007 19:39:10 GMT

Hi!

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

RE: Parent-Child in Grids

Greg McGuffey — Fri, 08 Jun 2007 15:06:25 GMT

Well, typically, I'd figure out what's going on in the parent BO's navigated event. This is fired after the parent navigates to a new row. At that point you could then call the fill method that fills the child. I.e.

[codesnippet]Private Sub parentBO_Navigated(ByVal sender As Object _
, e As Microfour.StrataFrame.Business.NavigatedEventArgs) Handles parentBO.Navigated
'-- Validate that there is a current row.
If Me.parentBO.CurrentRowIndex < 0 Then Return

'-- Get the parent ID
' where PKField is the name of the PK field of the parent...
Dim id As Integer = Me.parentBO.PKField

'-- Load the child: two options
' First, if there is a parent child relationship set for these BOs...
Me.childBO.FillByParentPrimaryKey(id)

' Second, use your sproc fill method
Me.childBO.FillBySproc(id)
End Sub[/codesnippet]

Obviously, you'd pick one method to fill the child BO. This method would not use the filtering of the child when a new parent is navigated to (the whole point of that would be to avoid all this code). Hope this helps!

RE: Parent-Child in Grids

Sarosh — Fri, 08 Jun 2007 13:59:21 GMT

Hi!

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

RE: Parent-Child in Grids

Greg McGuffey — Fri, 08 Jun 2007 12:40:02 GMT

I can help with 3] retrieving data using sprocs (assuming that's what SPs means!)

In a fill method using code something like this:

[codesnippet]Public Sub FillBySproc(ByVal paramValue As Integer)
Using cmd As New SqlCommand()
cmd.CommandType = Data.CommandType.StoredProcedure
cmd.CommandText = "sp_YourSproc"

'-- Setup parameters (add for any parameters needed by the sproc)
cmd.Parameters.Add("param1",Data.SqlDbType.Int)
cmd.Parameters("@param1").Value = paramValue ' Passed in value

'-- Load the data table
Me.FillDataTable(cmd)
End Using
End Sub[/codesnippet]

The sproc should return the records to fill the BO. The field order doesn't matter, but the name of the columns does - it should match the field names mapped to the BO.