Master-> Detail-> Detail with datagrids

[solex]

Hello,

I am trying (unsuccessfully ) to display a Master-Detail-Detail records. The
problem comes in the second detail grid. The first detail grid is
displaying correctly but it is not controlling the second grid. Here is
some code that I am using to initialize the binding:

txtName.DataBin dings.Add("Text ", dsFundOwner, "FundOwner.Name ")
txtNote.DataBin dings.Add("Text ", dsFundOwner, "FundOwner.Note ")
txtInformationS ource.DataBindi ngs.Add("Text", dsFundOwner,
"FundOwner.Info rmationSource")
txtLocation.Dat aBindings.Add(" Text", dsFundOwner, "FundOwner.Loca tionState")
txtCountry.Data Bindings.Add("T ext", dsFundOwner, "FundOwner.Coun try")
txtFounder.Data Bindings.Add("T ext", dsFundOwner, "FundOwner.Foun der")
txtTotalManaged .DataBindings.A dd("Text", dsFundOwner,
"FundOwner.Tota lManaged")
txtTotalManaged Notes.DataBindi ngs.Add("Text", dsFundOwner,
"FundOwner.Tota lManagedNotes")
txtRaiseNewFund .DataBindings.A dd("Text", dsFundOwner,
"FundOwner.Expe ctedToRaiseNewF und")
txtNewFundDate. DataBindings.Ad d("Text", dsFundOwner,
"FundOwner.Expe ctedToRaiseNewF undDate")
dgSubsidiaries. DataSource = dsFundOwner
dgSubsidiaries. DataMember = "FundOwner.Fund Owner_Subsidiar y"

' This grid is not displaying correctly when the dgSubsidiaries record
pointer is changed
dgFunds.DataSou rce = dsFundOwner
dgFunds.DataMem ber = "Subsidiary.Sub sidiary_Fund"

Any Suggestions?

Thanks,
Dan

[Ken Tucker [MVP]]

Hi,

Use Datagrid.SetDat abinding. Here is an example which uses the
northwind database.

Dim ds As DataSet

Dim daEmployees As SqlDataAdapter

Dim daOrders As SqlDataAdapter

Dim daOrderDetails As SqlDataAdapter

Dim conn As SqlConnection

Dim strConn As String

Dim strSQL As String

Dim strItem As String

Dim ctrl As Control

For Each ctrl In Me.Controls

If TypeOf ctrl Is DataGrid Then

Dim dg As DataGrid = ctrl

dg.AllowNavigat ion = False

End If

Next

strConn = "Server = " + Environment.Mac hineName + "\VSdotNet; "

strConn += "Database = NorthWind;"

strConn += "Integrated Security = SSPI;"

conn = New SqlConnection(s trConn)

ds = New DataSet

daEmployees = New SqlDataAdapter( "Select * from Employees", conn)

daOrders = New SqlDataAdapter( "Select * from Orders", conn)

daOrderDetails = New SqlDataAdapter( "Select * from [Order Details]", conn)

daEmployees.Fil l(ds, "Employee")

daOrders.Fill(d s, "Orders")

daOrderDetails. Fill(ds, "OrderDetai ls")

ds.Relations.Ad d("EmployeeOrde r",
ds.Tables("Empl oyee").Columns( "EmployeeID "), _

ds.Tables("Orde rs").Columns("E mployeeID"))

ds.Relations.Ad d("Order2Detail s", ds.Tables("Orde rs").Columns("O rderID"), _

ds.Tables("Orde rDetails").Colu mns("OrderID"))

dgEmployees.Set DataBinding(ds, "Employee")

dgOrders.SetDat aBinding(ds, "Employee.Emplo yeeOrder")

dgOrderDetails. SetDataBinding( ds, "Employee.Emplo yeeOrder.Order2 Details")

Ken

-------------------

"solex" <so***@nowhere. com> wrote in message
news:uu******** *****@TK2MSFTNG P11.phx.gbl...

Hello,

I am trying (unsuccessfully ) to display a Master-Detail-Detail records. The problem comes in the second detail grid. The first detail grid is
displaying correctly but it is not controlling the second grid. Here is
some code that I am using to initialize the binding:

txtName.DataBin dings.Add("Text ", dsFundOwner, "FundOwner.Name ")
txtNote.DataBin dings.Add("Text ", dsFundOwner, "FundOwner.Note ")
txtInformationS ource.DataBindi ngs.Add("Text", dsFundOwner,
"FundOwner.Info rmationSource")
txtLocation.Dat aBindings.Add(" Text", dsFundOwner, "FundOwner.Loca tionState") txtCountry.Data Bindings.Add("T ext", dsFundOwner, "FundOwner.Coun try")
txtFounder.Data Bindings.Add("T ext", dsFundOwner, "FundOwner.Foun der")
txtTotalManaged .DataBindings.A dd("Text", dsFundOwner,
"FundOwner.Tota lManaged")
txtTotalManaged Notes.DataBindi ngs.Add("Text", dsFundOwner,
"FundOwner.Tota lManagedNotes")
txtRaiseNewFund .DataBindings.A dd("Text", dsFundOwner,
"FundOwner.Expe ctedToRaiseNewF und")
txtNewFundDate. DataBindings.Ad d("Text", dsFundOwner,
"FundOwner.Expe ctedToRaiseNewF undDate")
dgSubsidiaries. DataSource = dsFundOwner
dgSubsidiaries. DataMember = "FundOwner.Fund Owner_Subsidiar y"

' This grid is not displaying correctly when the dgSubsidiaries record
pointer is changed
dgFunds.DataSou rce = dsFundOwner
dgFunds.DataMem ber = "Subsidiary.Sub sidiary_Fund"

Any Suggestions?

Thanks,
Dan