title: VB.NET Datatable.Select expression
body: <p>is it possible to use filter expression to select some columns?
  something like <code>select a,b,c from table</code> in sql</p>
  
  <p>here is what i am trying to do</p>
  
  <pre><code> Dim rows() As DataRow = bookedorders.Select("a,b,c")   'select columns a b c only, i know its wrong
          Dim zzz As DataTable = rows.CopyToDataTable
  </code></pre>
  
  <p>so is it possible to use the Datatable.Select to select columns and the use a condition like sql <code>WHERE a=1</code></p>
  
  <p>my linq try was</p>
  
  <pre><code>Dim q = From r In bookedorders.AsEnumerable Select r.Field(Of Integer)("a") And r.Field(Of String)("b") And r.Field(Of String)("c") And r.Field(Of Integer)("d")
          For Each m In q
              zzz.Rows.Add(m)
          Next
  </code></pre>
  
  <p>which doesnt seem to work, it says that the number of items in array is longer than the datatable!</p>