title: DataTable Select & DataView Sort
body: <p>Quick Question.
  When I use a DataTable.Select("..") without a Sort condition after using a DataView to Sort the DataTable, should the records be returned in Sorted order ?
  Using this method I find that in some cases the records aren't being returned in the correct order, it's hit and miss as well - sometimes they are sometimes they aren't. 
  If I specify a sort condition to the Select then it all works fine, but the performance implications are drastic for large DataTables. </p>
  
  <p>I've tried using the DataView RowFilter to reduce the hitset but every time I change the RowFilter the performance goes south</p>
  
  <pre><code>MyDtable.Load(MyReader);  // its am Oracle DataReader
  MyView = new DataView(MYDtable);
  MyView.Sort = "CODE, TABLE DESC";
  
  DataRow[] MyRecs = MyDtable.Select("TABLE &gt; 'FREDDO' AND CODE &gt; '661991'");
  </code></pre>
  
  <p>The number of records returned is always correct, it's just the order that may vary (sometimes)</p>
  
  <p>Thanks,
  John</p>