如何在vb.net中使用where子句中的date从access数据库中检索数据？

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\database.accdb"
Dim connection As New OleDbConnection(connectionString)

connection.Open()

Dim query As String = "SELECT * FROM TableName WHERE DATE(dateColumn) = @dateParam"

Dim command As New OleDbCommand(query, connection)

command.Parameters.AddWithValue("@dateParam", yourDateValue)

Dim reader As OleDbDataReader = command.ExecuteReader()

While reader.Read()
    ' 处理每一行数据
    Dim value As String = reader.GetString(0) ' 假设第一列是字符串类型
    Console.WriteLine(value)
End While

reader.Close()
connection.Close()