title: Refresh TextBoxes on TextChanged Event
body: <pre><code>private void txtItems_TextChanged(object sender, EventArgs e)
  {
     try
     {
        MySqlCommand com = new MySqlCommand();
        MySqlDataReader read;
        com.CommandText = "SELECT * FROM Inventory where ProductID ='" + txtbCode.Text + "'";
        com.Connection = MySQLConnection.con;
        MySQLConnection.con.Open();
        read = com.ExecuteReader();
        while (read.Read())
        {
           txtCatogery.Text = read["Catogery"].ToString();
           txtDiscriptions.Text = read["Description"].ToString();
           txtQTY.Text = read["QTY"].ToString();
           txtPrice.Text = read["Price"].ToString();
        }
      //Rest of code
     }
  }
  </code></pre>
  
  <p>When I type a barcode in <code>txtbCode</code> the TextBoxes are get in the values from db, but if I have a product with bar code <code>1234</code> continue typing 56 (123456) I have no products with that bar code but the values of the textboxes wont refresh, they keep the values that are read about 1234.</p>
  
  <p>How do I achieve that?</p>