G
Guest
DataSet relationships seem to be focussed on one to many type realtionships.
I have got a one to one realtionship in a DataSet between two tables. I
can't do a join between the two tables in the database because the tables
come from different databases (although held on the same server). However
what i want is a single set of data that combines the fields like you get
with an SQL join. Is there a straight forward way of doing this that i am
missing because the only way i can see is to iterate through the parent table
calling GetChildRows for each record and then sticking each individual value
in a third seperate DataTable. Is there an easier way to do this?
I have got a one to one realtionship in a DataSet between two tables. I
can't do a join between the two tables in the database because the tables
come from different databases (although held on the same server). However
what i want is a single set of data that combines the fields like you get
with an SQL join. Is there a straight forward way of doing this that i am
missing because the only way i can see is to iterate through the parent table
calling GetChildRows for each record and then sticking each individual value
in a third seperate DataTable. Is there an easier way to do this?