如何从Access数据库VB.net中检索特定数据？

Imports System.Data.OleDb

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\your\database.accdb"
        Dim query As String = "SELECT * FROM TableName WHERE ColumnName = @Value"

        Using connection As New OleDbConnection(connectionString)
            Using command As New OleDbCommand(query, connection)
                command.Parameters.AddWithValue("@Value", "specific value")

                connection.Open()

                Using reader As OleDbDataReader = command.ExecuteReader()
                    While reader.Read()
                        ' 处理检索到的数据
                        Dim columnValue As String = reader("ColumnName").ToString()
                        ' ...
                    End While
                End Using
            End Using
        End Using
    End Sub
End Class