title: Querying datasets vb.net
body: <p>I'm working with an external access database (.accdb) in VB.NET and I'm trying to limit the amount of times that my [Winforms] program pings the data since it slows it down pretty considerably. I figured I could do this by querying my in-memory dataset instead of continuously going back to the database itself. Though, unfortunately, I cannot seem to figure out how to query my in-memory dataset. I tried looking up LINQ but couldn't find any instructions on how to set it up. </p>
  
  <p>Am I missing something? Is there a better way to do this? </p>
  
  <p>Thanks so much! My starting code below...</p>
  
  <pre><code> locsql = "SELECT * FROM TABLE1)
   Dim objAdapter As New OleDb.OleDbDataAdapter(locsql, objconn)
   objAdapter.Fill(locdata, "BASE")
  </code></pre>
  
  <p>So I can easily do some basic things I need with <code>locdata("BASE").rows.item("Item")</code> but I have to do some stuff like 
  <code>SELECT thing FROM TABLE1 WHERE this = this and that = that</code> and I would just rather not keep going back to the database if possible.</p>
  
  <p>Is it possible?</p>