Data Type Mismatch

[Aruna Dalvi]

Hi friend
Please tell me why this error is occured in following code

error=ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

cmd = New OdbcCommand("INSERT INTO TableHR1 (No,name_of_candidate,Address,Date_of_birth,PhoneN o,Email, _
Design_Eng,CAE_Eng,Mkt,Accounting,It,Admin ,Experience,Industry,Current_CTC,InHand,ExpectedCT C, _
Exp_Inhand,Joining_Period,Iziel_Result,Iziel_Rem ark,Candidate_Remark) " _
& " VALUES ( '" + notxt.Text + "', '" + nametxt.Text + " ','" + Addresstxt.Text + _
" ',' " + DateOfBirthtxt.Text + "','" + Phonetxt.Text + "',' " _
 + Emailtxt.Text + " ','" + TextBox2.Text + "','" + TextBox3.Text _
+ "',' " + TextBox7.Text + "','" + TextBox4.Text + "','" + TextBox8.Text _
 + "','" + TextBox5.Text + "',' " + TextBox1.Text + "','" + TextBox6.Text _
+ "','" + CurrentCTCtxt.Text + "' ,'" + Inhandtxt.Text + "', '" + ExpectedCTCtxt.Text _
+ " ', '" + Expectedinhand.Text + "' ,' " + joiningtxt.Text + " ', '" _
+ iZielResultktxt.Text + " ','" + IzielRemarktxt.Text + "','" + CandidateResulttxt.Text + "')", con)

[Stewart Ross]

You are treating every field as being text - each VALUE in your insert statement is being enclosed in single quotes. One or more of these fields is not of type text in the underlying table. You will need to find out which yourself, as you give no clues to us in your question other than in names of fields such as date_of_birth, which would not normally be a text field.

-Stewart