This problem, 'Data type mismatch in criteria expression.', has been giving me problems

Question

This is my code and I'm not sure what's wrong

Dim strsql As String

    strsql = "Insert into Tbltenants (id,housenumber,lastname,firstname,phonenumber,email,term,payment_by,rent_paid) VALUES(@id,@housenumber,@lastname,@firstname,@phonenumber,@email,@term,@payment_by,@rent_paid)"

    Dim cmd2 As New OleDbCommand(strsql, conn)

    cmd2.Parameters.AddWithValue("@id", IDTextBox.Text)

    cmd2.Parameters.AddWithValue("@house number", House_NumberTextBox.Text)

    cmd2.Parameters.AddWithValue("@last name", Last_NameTextBox.Text)

    cmd2.Parameters.AddWithValue("@first name", First_NameTextBox.Text)

    cmd2.Parameters.AddWithValue("@phone number", Phone_NumberTextBox.Text)

    cmd2.Parameters.AddWithValue("@email", EmailTextBox.Text)

    cmd2.Parameters.AddWithValue("@term", TermTextBox.Text)

    cmd2.Parameters.AddWithValue("@payment by", Payment_byTextBox.Text)

    cmd2.Parameters.AddWithValue("@rent paid", Rent_paidTextBox.Text)

    conn.Open()

    cmd2.ExecuteNonQuery()

    conn.Close()

    bind_data()

Please help me.

Answer 1

Hi, Welcome to Microsoft Q&A.

A possible cause of this problem is that the fields in the database do not match the data types of the parameters passed to the query.

Please make sure that the data type of each parameter matches the data type of the target column.

For example, to convert a string to a numeric format in an Access database, you can use conversion functions such as Convert.ToByte, Convert.ToInt16, Convert.ToInt32, Convert.ToInt64, Convert.ToSingle, Convert.ToDouble, Convert.ToDecimal, and so on.

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi, please check the datatype of each column of the table and the value of the parameter provided. Seems like provided parameters datatype and column datatype are not matching.