Checking access database


I am trying to compare the values in my dictionary which contains values/quantities to a standard database containing similar values/quantities. I want to check if the value matches the database, then check if the quantity is less than the database.

I keep getting an error when I run the code on the "Using myreader" line, with the following: System.Data.OleDb.OleDbException: 'IErrorInfo.GetDescription failed with E_FAIL(0x80004005).' This is my first time using OleDBDatareader so perhaps I am doing something incorrectly. Is this not allowed, I assumed comparing a list a values in a dictionary should be possible.

Dim myconnection As OleDbConnection
    Dim constring As String = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\UsersTables.accdb; Persist Security Info=False"
    myconnection = New OleDbConnection(constring)
    Dim keepSell As String
    For Each KeyPair In colSums
        Dim sqlQry As String
        sqlQry = "SELECT Part,Quantity FROM PartsList WHERE Item = '" & keyPair.Key & "'AND Size= '" & keyPair.Value & "'"
        Dim cmd As New OleDbCommand(sqlQry, myconnection)
        Using myreader As OleDbDataReader = cmd.ExecuteReader()
            If myreader.Read() Then
                keepSell = "Keep"
                keepSell= "Sell"
            End If
        End Using
            DataGridView1.Rows.Add(KeyPair.Key, KeyPair.Value, keepSell)
asked on Stack Overflow Nov 18, 2020 by lerne8423

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0