ADO.Net Question/Problem

[Sterling33]

Hi All,
I'm still coming to grips with ADO.Net in VB.Net. What I'm attempting to do is create a dataset containing 2 tables(tbl_mft and tbl_soft), and have my program loop through the tbl_mft table for a specific Manufacturer Name. And if that name is found, move to the mft_soft Table and look for a specific software name. Any sample code that anyone could share with me would be great. Below is a snibbet of the 2 tables I have in MS Access:

tbl_mft
mftID
mftName

tbl_soft
softID
mftID
softName

Thanks,
-Sterling