: Data type mismatch in criteria expression

 when iam select id in dropownlist iwant to display stuentname in textbox...

 

when iam use below code it shos error like.....

System.Data.OleDb.OleDbException: Data type mismatch in criteria expression. 

 

 

string value1 = txtseach.Text;

OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\TecbuzzDb\\techdb.accdb");

con.Open();

OleDbCommand cmd = new OleDbCommand("select ID ,Student_name, Mobile from stuentregistration WHERE ID='" + value2 + "'", con);

OleDbDataAdapter da = new OleDbDataAdapter(cmd);

// DataSet ds = new DataSet();

DataTable DT = new DataTable();

da.Fill(DT);