I want to load a dataset so that the only rows loaded in the child tables are those with a matching parent record. I do not want to load everything into the dataset and filter data. I want a dataset with the data for one project in it.
A building exists at 123 Main St with 5 units, each unit then has 8 rooms
So I would have the following tables: tBulding, tUnits,tRooms
tBuilding could have many records.
How could I create a dataset with just the info for 123 Main St, instead of loading a dataset with all the records and then filtering it.
I would like to keep the data in its separate tables rather than try to load one giant table.
The idea is to send the data for the single building electronically.
I know how to load the (parent) tBuilding data properly but how can I load only the rows in the child tables with matching parent records? I thought that some simple method would be available to perform this but I cannot locate one in any of the many books I have.
This process would be performed in a VB.Net Compact app running on a pocket pc so using memory efficiently is a consideration.
Thanks in advance for the help.