title: Finding Records in a Database using a Textbox and Search Button in VB.Net
body: <p>I am Trying to Create a Library management system, I am a beginner at coding. The Problem I am having is I want to search my books database by title in Visual Basic, using a Textbox and Search button and wanting it to display the results in an seperate form. How would I go about a search in my database in visual basic.</p>
  
  <p>I have imported my database into visual basic. I have used the query below to make it work in Microsoft Access, but couldn't in Visual Basic.
  The Query I used in Microsoft access was this:</p>
  
  <pre><code>SELECT Books.[Book ID], Books.Title, Books.Author, Books.Category, Books.Location, Books.[Fiction/Non-Fiction], Books.Loaned
  
  FROM Books
  
  WHERE (((Books.Title) Like [Search Certin Title] &amp; "*"));
  </code></pre>
  
  <p>Please help me in this regard.</p>