title: Change the sequens of columns in datatable with linq
body: <p>I have a Datatable with the columns </p>
  
  <pre><code>Name|Age|Job
  </code></pre>
  
  <p>I query that Datatable with Linq and do some manipulations. </p>
  
  <pre><code>Dim query = From row in dt.AsEnumerable.where(...)
  </code></pre>
  
  <p>The returned object is a datatable that I need for further procedures.
  But now I have to change the column sequence to</p>
  
  <pre><code>Age|Name|Job
  </code></pre>
  
  <p>and do not know how to do that. 
  I tried:</p>
  
  <pre><code>Dim query1 = From column In query
  Select column.Age, column.Name, column.Job
  </code></pre>
  
  <p>But query1 is not a Datatable object anymore. Could anyone help me get the resorting of the columns done that I still have a datatable object?</p>