title: An unhandled exception of type 'System.Data.OleDb.OleDbException' Additional information: Data type mismatch in criteria expression
body: <p>I'm trying to get the price from a item in a combobox.Any ideas?</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Drawing;
  using System.Linq;
  using System.Text;
  using System.Threading.Tasks;
  using System.Windows.Forms;
  using System.Data.OleDb;
  
  namespace Aplicatie_proiect
  {
      public partial class Form2 : Form
  
      {
          private OleDbConnection connection = new OleDbConnection();
          public Form2()
          {
              InitializeComponent();
              connection.ConnectionString =    @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\SleepyHitman-      V2\Documents\Inventory1.accdb;
      Persist Security Info=False;";
          }
  
          private void txt_order_Click(object sender, EventArgs e)
          {
              Double PT = new Double();
              connection.Open();
              OleDbCommand command = new OleDbCommand();
              command.Connection = connection;
              command.CommandText = "insert into Comenzi (Produs,Cantitate) values('"+txt_Produs.Text+"','"+txt_Cantitate.Text+"',)" ; //+ sa adaug useru care e logat din form 1
              command.ExecuteNonQuery();
              connection.Close();
          }
  
          private void Form2_Load(object sender, EventArgs e)
          {
              connection.Open();
              OleDbCommand command = new OleDbCommand();
              command.Connection = connection;
              string query = "select * from Inventory";
              command.CommandText = query;
              OleDbDataReader reader = command.ExecuteReader();
  
              while (reader.Read())
              {
                  txt_Produs.Items.Add(reader["Produs"].ToString());
              }
              connection.Close();
  
          }
          private void txt_Produs_SelectedIndexChanged(object sender, EventArgs e)
          {
              **connection.Open();
              OleDbCommand command = new OleDbCommand();
              command.Connection = connection;
              string query = "select * from Inventory where Pret ='" + txt_Produs.Text + "'";
              command.CommandText = query;
              OleDbDataReader reader = command.ExecuteReader();
  
              while (reader.Read())
              {
                  txt_Pret.Text = reader["Pret"].ToString();
  
              }
              connection.Close();**
          }
      }
   }
  </code></pre>