Member Avatar for mercury113

data type mismatch criteria error .. please help im getting this error .. and i don't know where's the error ..

Private Sub frmUpdateChapter_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\dbCAI.mdb"

        con.Open()

        Try

            da = New OleDb.OleDbDataAdapter("SELECT * from tblChapter WHERE ChapterNo='" & ComboBox1.SelectedItem & "'", con)

            da.Fill(ds, "tblChapter")
            dt = ds.Tables("tblChapter")

        Catch ex As Exception

            MessageBox.Show(ex.Message)

        End Try

        txtChapterName.Text = dt.Rows.Item(0).Item(0)

        con.Close()

    End Sub
  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by apegram
Member Avatar for apegram

Is ChapterNo a text or numeric data field?

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.