title: C# - Filtering with DataView
body: <p>I have a dataset full of order information and I am trying to filter the dataset with DataView. </p>
  
  <p>This is what I have so far. This returns all the columns in the DataSet. </p>
  
  <pre><code>DataTable orders = dataSet.Tables[0];
  
  EnumerableRowCollection&lt;DataRow&gt; query = from order in orders.AsEnumerable()
                                       where order.Field&lt;Int16&gt;("OrderID") = 2 
                                       select order;
  
  DataView view = query.AsDataView();
  </code></pre>
  
  <p>What I want to do is that the query only return some columns not all of them. What do I do?</p>