Retrieving rows from childtabel in ado.net 1.1 (net 2003)

Hot Topic

Binding Navigator Problem
How do I draw an image at the actual size (pixel-wise)?
Form.Show() shows form minimized!
DataGridViewComboBoxColumn Editing
editing items in a listbox
windows forms as excel sheet editor
Recommend Good API book for C#
icons
Problems with setup project - am I thick?
Embedded Resource rather than a project reference

Windows Forms

how can i reset form's controls
Struggling with no touch deployment
App Settings & configurations
Huge bug ?
Tab pages on windows forms
Is there a Non-Databound Grid?
modifying control properties
How to detect arrow keys in vb.net?
VS 2005 XPS C# - WebBrowser control not opening https:// sites
Prevent insert in a datagrid

Retrieving rows from childtabel in ado.net 1.1 (net 2003)

Hi again

I'm trying to retrieve the data from a childtable in a relationship like so

For Each row As DataRow In DsSPAM1.Relations(0).ChildTable.Rows
TmpStr += row.Item("NaamGebruiker").ToString.Trim & ": " & _
row.Item("StatusOmschrijving").ToString & vbCrLf
Next

But this gives me all th record and not the records related to the record in the parent table.

tnx and regards

Remco

Answer this question

Retrieving rows from childtabel in ado.net 1.1 (net 2003)

  • Chris Han MSFT

    c'mon guys

    remco

  • Joshua Tipton

    To get child rows for a particular parent row use:

    DataRow.GetChildRows(...)



  • charlie_mtz

    VKH txn got it working. pretty ugly but it works

    stapRow As DataRow
     
    stapRow = CType(Me.BindingContext(DsSPAM1, "Stappen").Current, DataRowView).Row
     
    For Each row As DataRow In stapRow.GetChildRows(DsSPAM1.Relations(0))
     
    TmpStr += row.Item("NaamGebruiker").ToString.Trim & ": " & _
     row.Item("StatusOmschrijving").ToString & vbCrLf
     
    Next
     

    Regards remco

     
  • Retrieving rows from childtabel in ado.net 1.1 (net 2003)
Answer this question