title: select with index on DataTable?
body: <p>After I get DataTable from sqlAdapter I'm closing connection.
  If I preform SELECT from this DataTable, does the select use the index 
  I created in the DB?</p>
  
  <p>what code do I need to write for using the index?</p>