title: loop to add data from a different datatable
body: <p>My DataTable which I want to call to my 2nd table:</p>
  
  <p>First table: </p>
  
  <pre><code> Dim table As New DataTable
  
   ' columns in the DataTable.
   table.Columns.Add("Monday", System.Type.GetType("System.Int32"))
   table.Columns.Add("Tuesday", System.Type.GetType("System.Int32"))
   table.Columns.Add("Wednesday", System.Type.GetType("System.Int32"))
   table.Columns.Add("Thursday", System.Type.GetType("System.Int32"))
   table.Columns.Add("Friday", System.Type.GetType("System.Int32"))
   '  rows with those columns filled in the DataTable.
   table.Rows.Add(1, 2005, 2000, 4000, 34)
   table.Rows.Add(2, 3024, 2343, 2342, 12)
   table.Rows.Add(3, 2320, 9890, 1278, 2)
  </code></pre>
  
  <p>now this is my 2nd table which i need to loop:</p>
  
  <p>** not finished, want to add 1 from table to table2, in the first row.**</p>
  
  <pre><code>   Dim table2 As New DataTable
  
  
      ' columns in the DataTable.
      table2.Columns.Add("one", System.Type.GetType("System.String"))
      table2.Columns.Add("two", System.Type.GetType("System.String"))
  
      table2.Rows.Add()  *** add 1 (from monday) from first table**** ??
      table2.Rows.Add()
      table2.Rows.Add()
      table2.Rows.Add()
  </code></pre>
  
  <p>Using the table2, how can i link the information of Monday, to add in one in table 2, i will need a loop i think to call it.</p>
  
  <p>In the first table, i want 1 that is in monday to show in "one" which is in the 2nd table, table2.</p>
  
  <p>For alex:</p>
  
  <pre><code> Monday    Tuesday    Wed
   10           40       9
   20           50       6
   30           70       4
  </code></pre>