title: How to split a DataTable in two separate by columns
body: <p>I have a DataTable which has many columns and only one row:</p>
  
  <pre><code>...
  DataSet myDataSet = new DataSet();
  da.Fill(myDataSet);
  
  myDataTable = new DataTable();
  myDataTable = myDataSet.Tables[0];
  ...
  </code></pre>
  
  <p>How can I split the DataSet/DataTable to have equal amount of columns (if it is an odd number, split the columns so the first <code>DataTable</code> has the extra column).</p>
  
  <p>Scenario #1:</p>
  
  <p>Main <code>DataTable</code>:</p>
  
  <pre><code>col1    col2    col3    col4    col5    col6    col7    col8
  9       0       9       5       7       4       9       3
  </code></pre>
  
  <p><code>DataTable1</code>:</p>
  
  <pre><code>col1    col3    col3    col4
  9       0       9       5
  </code></pre>
  
  <p><code>DataTable2</code>:</p>
  
  <pre><code>col5    col6    col7    col8
  7       4       9       3
  </code></pre>
  
  <p>Scenario #2:</p>
  
  <p>Main <code>DataTable</code>:</p>
  
  <pre><code>col1    col2    col3    col4    col5    col6    col7
  9       0       9       5       7       4       9
  </code></pre>
  
  <p><code>DataTable1</code>:</p>
  
  <pre><code>col1    col3    col3    col4
  9       0       9       5
  </code></pre>
  
  <p><code>DataTable2</code>:</p>
  
  <pre><code>col5    col6    col7
  7       4       9
  </code></pre>