title: How to Show my My Queried Data using OleDbDataReader vb
body: <p>I know this a walk in the park for most of you on this site, but for a n00b like me it is giving me a little trouble now, all i'm trying to do is program my "Query" button to show/search data from my access file based on a string entered in a corresponding textbox. For example if your trying to search the access db for all employees named Eric. I want to be able to type Eric in my FirstName txtbox and show a list of all employees named Eric within my access file. So far I have some code that runs without error but when I click the button whatever is in my textbox disappears. I positive im missing something and just need some guidance. here is my code so far.Doing this in VB so please HELP!!!</p>
  
  <pre><code>Using con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Eric\Documents\Fadv.accdb")
          Dim SQL As String = ("SELECT FirstName, LastName FROM info")
  
          Dim cmd As New OleDbCommand(SQL, con)
          con.Open()
  
          Dim reader As OleDbDataReader
          reader = cmd.ExecuteReader()
  
          While reader.Read()
              txtFirstName.Text = reader(0).ToString()
  
              Console.WriteLine(" {0} = {1}", reader("FirstName"), 
                  reader("LastName"))
  
              txtFirstName.Text = reader(0).ToString()
  
          End While
          reader.Close()
  
  End Using
  </code></pre>