title: C# DataSet.Relations: How to use DataSet Relations?
body: <p>I have 3 tables and I have made relations to each of them.</p>
  
  <p>let say: 
  table 1 has:
  aID, bID, cID, someText and someNumber</p>
  
  <p>table 2 has:
  bID, txtValueTable2, someText</p>
  
  <p>table 3 has:
  cID, txtValueTable3, someText</p>
  
  <p>some code:</p>
  
  <pre><code>ds.Relations.Add("BrandNameStr", ds.Tables[1].Columns["bID"], ds.Tables[0].Columns["bID"]);
              ds.Relations.Add("IngredientStr", ds.Tables[2].Columns["cID"], ds.Tables[0].Columns["cID"]);
  </code></pre>
  
  <p>Now I want to use the columns off all 3 tables to make 1 dataset, but I don't know how?</p>
  
  <p>The dataset must have the following columns:
  aID, txtValueTable2, txtValueTable3, someText and someNumber</p>
  
  <p>Can someone help me?</p>