JMO9966
asked on
VB.Net GetChildRows command ?
Hello,
I'm using the following code to retrieve Child rows from a VB.Net DataRelation.
drVendorsMain = New DataRelation("drVendorsMai n", dsMRP.Tables("Material").C olumns("Ma terial"), dsMRP.Tables("Vendor_Mater ial").Colu mns("Mater ial"), False)
dsMRP.Relations.Add(drVend orsMain)
What I'm trying to do is loop through multiple rows that may be returned by the GetChildRows command. Here's my code that collects the value from one row, but I need to retrieve multiple rows one at a time in certain cases. Please help.
Dim dRows() As System.Data.DataRow = dsMRP.Tables("Material").R ows(i).Get ChildRows( "drVendors Main")
If dRows.GetLength(0) > 0 Then
BackupVendor = dRows(0).Item("Backup_Vend or")
End If
Thanks,
JMO9966
I'm using the following code to retrieve Child rows from a VB.Net DataRelation.
drVendorsMain = New DataRelation("drVendorsMai
dsMRP.Relations.Add(drVend
What I'm trying to do is loop through multiple rows that may be returned by the GetChildRows command. Here's my code that collects the value from one row, but I need to retrieve multiple rows one at a time in certain cases. Please help.
Dim dRows() As System.Data.DataRow = dsMRP.Tables("Material").R
If dRows.GetLength(0) > 0 Then
BackupVendor = dRows(0).Item("Backup_Vend
End If
Thanks,
JMO9966
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.