data type mismatch in criteria expression vb.net access

Question

This My Code

Public Function simpan() As Integer Dim sql As String Dim cmmd As OleDbCommand

    sql = "INSERT INTO disposisi    (nodisposisi,noagendamasuk,idseksi,intruksi,tgldisposisi,nosurat,perihal,nama)" & _
    "values(?,?,?,?,?,?,?,?)"
    cmmd = New OleDbCommand(sql, cnn)
    cmmd.CommandType = CommandType.Text
    cmmd.Parameters.AddWithValue("nodisposisi", FNoDisposisi)
    cmmd.Parameters.AddWithValue("noagendamasuk", FAgenda)
    cmmd.Parameters.AddWithValue("idseksi", FIdSeksi)
    cmmd.Parameters.AddWithValue("intruksi", FIntruksi)
    cmmd.Parameters.AddWithValue("tgldisposisi", FTgl)
    cmmd.Parameters.AddWithValue("nosurat", FNoSrt)
    cmmd.Parameters.AddWithValue("perihal", FPerihal)
    cmmd.Parameters.AddWithValue("nama", FNama)

    Return cmmd.ExecuteNonQuery()
End Function

I don't know what i do please help me

What is the specific problem that you're having? – Stonz2 Jul 17 '14 at 13:03 — Stonz2, Jul 17 '14 at 13:03

score 0 · Answer 1 · answered Jul 18 '14 at 05:16

0

probably the data type you are trying to insert in table is not what that column is expecting

like you are inserting char in int column .you need to check table definition.You have to

look at the Databases's expected datatype to know for sure

answered Jul 18 '14 at 05:16

Anand

621
3
9
31

data type mismatch in criteria expression vb.net access

1 Answers1