vb.net - VB.NET中无法识别的数据库格式错误

Question

我使用 dbf/dbase 数据库时出错。

我想使用CPN数据库中列的值创建一个组合框，并且我只想显示QOH列不为零或空白的数据。

这是我到目前为止所拥有的：

Dim Builder As New OleDb.OleDbConnectionStringBuilder With
    {
        .Provider = "Microsoft.Jet.OLEDB.4.0",
        .DataSource = IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop))
    }
      
Builder.Add("Extended Properties", "dBase IV") 'I added this code but still error'
Dim dt = New DataTable()
Using adapter As New OleDbDataAdapter("select CPN,ITM,ITC,QOH,PRS FROM IFG WHERE QOH > 0", Builder.ToString)
    adapter.Fill(dt)
End Using
Me.DataGridView1.DataSource = dt
'ADD CODE FOR COMBOBOX
Private Sub ComboBox1_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
        Dim dv As DataView = dt.DefaultView
        dv.RowFilter = String.Format("ITM  LIKE '%{0}%'", ComboBox1.SelectedItem.ToString())
        DataGridView1.DataSource = dv

    End Sub

我看到这些错误：

我怎样才能解决这个问题？

标签： vb.netado.netdbfoledbconnection