title: simple asp.net search
body: <p>I am trying to add a search box in my page, where I can search the database.</p>
  
  <p>This is the code I have so far</p>
  
  <pre><code>Partial Class Search
      Inherits System.Web.UI.Page
  
      Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
  
  Select [Title]
  FROM [Books]
  WHERE ([Title].theName LIKE '%' )
  RETURN
  
  End Class
  </code></pre>
  
  <p>Basically I want the search to return any work that appears in the database or close to it.</p>