Member Avatar for chellemits

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. :(

  • 2 Contributors
  • 1 Reply
  • 146 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Pgmer
Member Avatar for Pgmer

Use convert.int(txtbkletnum1.text) or use txtbkletnum1.value instead of .text

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.