title: Show data in datagridview from multiple sources
body: <p>I have this code:</p>
  
  <pre><code>        DataTable s = produseTableAdapter.GetData();
          DataTable t = produse_magazinTableAdapter.GetData();
          foreach (DataRow row in s.Rows)
              if (row.ItemArray[2].Equals("consumabile"))
              {
                  t.Rows.Add(row);
              }
          dataGridView1.DataSource = t;
  </code></pre>
  
  <p>The problem is that dataGridView1 shows the data from : </p>
  
  <pre><code>        DataTable t = produse_magazinTableAdapter.GetData();
  </code></pre>
  
  <p>How can i solve this ?</p>