Get DataGridView.SelectedRows Children Data

[cday119]

Hi All,

I have a datagridview, and I'm looping threw the selected rows like so:

For Each row As System.Windows.Forms.DataGridViewRow In OrderDataGridView.SelectedRows

This DataGridView Holds Order Information and it contains a column called ShippingID, which is used as a foreign key relation to another table(ShippingA ddress) in the DataSet.

My question is how to I access the related ShippingAddress data? Basically I want to do something like this:

For Each row As System.Windows.Forms.DataGridViewRow In OrderDataGridView.SelectedRows

OrderdID = row.cells(1)
ShippingAddress1 = row.relatedtable.item("ShippingAddress1")

Next

Thanks
Chad