DataSets in C#.NET -- How to access related tables via a universal row <p>I have a situation where previously a simple DataTable worked (because I was using an DataAdapter that only hit <em>one</em> table in my relation system). Recently however I'm joining three tables (done in the query that gets sent to my rdb) and it looks can only access one via a DataTable.</p> <p>Is there a way to iterate over some universal row (i.e. one row that has columns of all tables joined via a foreign key link) element in a DataSet?</p> <p>Also currently all of this data from three tables is getting put into a single DataTable via OdbcDataAdapter.Fill(myDataTable). I would really like to be able to do something like:</p> <pre><code>string s1 = myDataTable.Rows[i]["table1.someCol"], s2 = myDataTable.Rows[i]["table2.someCol"]; </code></pre> <p>Are either of these possible, and if not how should one handle this situation? Thanks in advance.</p>