Thank you Cathi



>Ahmad,
>
>Here is some sample code from my ADO.NET session that shows how to iterate through the records. You use the GetChildRows to iterate through the child table:
>
>

>Dim ds As New DataSet()
>
>Dim strSQL As String = "SELECT Cust_ID, Order_Id, “ & _
>	“Order_Date FROM Orders WHERE Year(Order_Date) > 1997"
>Dim oda As New OleDbDataAdapter(strSQL, connStr)
>oda.Fill(ds, "OrderInfo")
>
>strSQL = "SELECT CustomerID FROM Customers “  & _
>	“ORDER BY CustomerID"
>Dim sda As New SqlDataAdapter(strSQL, connStr)
>sda.Fill(ds, "CustomerInfo")
>
>Dim dc1 As DataColumn = _
>	ds.Tables("CustomerInfo").Columns("CustomerId")
>Dim dc2 As DataColumn = _
>	ds.Tables("OrderInfo").Columns("Cust_Id")
>
>Dim dr As New DataRelation("CustomersToOrders", dc1, dc2)
>ds.Relations.Add(dr)
>
>Dim drCustomer As DataRow
>Dim drOrder As DataRow
>
>For Each drCustomer In ds.Tables("CustomerInfo").Rows
>	lstDemo.Items.Add("Customer: " & _
>	drCustomer("CustomerId").ToString())
>	' Iterate through related rows.
>	For Each drOrder In drCustomer.GetChildRows(dr)
>		lstDemo.Items.Add( _
>			String.Format("   Order {0} placed on {1:d}", _
>			drOrder("Order_ID"), drOrder("Order_Date")))
>	Next drOrder
>Next drCustomer
>

>
>>Hi All,
>>
>>I have 2 tables having a datarelation between them
>>the master table is "Member" an second table is "Subs", the relation is created as follow:
>>

>>myDS.Relations.Add("MemSub", myDS.Tables("Member").Columns("MemberID"), myDS.Tables("Subs").Columns("MemberID"))
>>

>>how to read the feilds from the datarelation, or how to create the datarow from the datarelation "MemSubs" to read the "subs" colums ?
>>
>>thanks for the help