Hi. Can someone help me with my problem?
Here is where the error occurs.
da = New OleDbDataAdapter("SELECT * FROM booklet WHERE booklet_num= '" & txtbkletnum1.Text & "'", con) cb = New OleDbCommandBuilder dt = New DataTable 'this became yellow and error appears as datatype mismatch in criteria expression. da.Fill(dt)
How can I fix this? BTW, the datatype of booklet_num in database is an integer/number(since i am using ms access)
PLEASE HELP. This is very urgent. :(