title: Search database with textbox
body: <p>First of all I am working at VB 2012.</p>
  
  <p>I have problem with searching my database. It goes so slow, actually filling the <code>ListView</code> is what bothers me.<br/>
  I have a text box with TextChange event. Its instant search. So when I'm starting to write in that text box it's starts to filter the database and filling the data in the <code>ListView</code>.</p>
  
  <p>This is the code in <code>text box</code> and the <code>Load</code> procedure</p>
  
  <pre><code>Private Sub txtID_TextChanged(sender As Object, e As EventArgs) Handles txtID.TextChanged
      Load("SELECT * FROM table WHERE id LIKE '" &amp; txtID.Text &amp; "%'")
  End Sub
  
  
  Private Sub Load(ByVal strQ As String)
      List.Items.Clear()
      cmd = New SqlClient.SqlCommand(strQ, con)
      dr = cmd.ExecuteReader()
      If dr.HasRows = True Then
          While dr.Read
              Dim X As ListViewItem
              X = List.Items.Add(dr(0))
              X.SubItems.Add(dr(2))
              X.SubItems.Add(dr(3))
              X.SubItems.Add(dr(4))
              X.SubItems.Add(dr(1))
              X.SubItems.Add(dr(5))            
          End While
      End If
  End Sub
  </code></pre>
  
  <p>So, every time I hit a letter it calls the load procedure.</p>
  
  <p>And I have so much data and it goes so slow. Can you help me somehow ? Is there any solution ?</p>