ACCESS中带有参数的日期之间的VB.net不起作用

Dim startDate As DateTime = New DateTime(2022, 1, 1)
Dim endDate As DateTime = New DateTime(2022, 12, 31)

Dim query As String = "SELECT * FROM TableName WHERE DateField BETWEEN #" & startDate.ToString("yyyy-MM-dd") & "# AND #" & endDate.ToString("yyyy-MM-dd") & "#"

Dim startDate As DateTime = New DateTime(2022, 1, 1)
Dim endDate As DateTime = New DateTime(2022, 12, 31)

Dim query As String = "SELECT * FROM TableName WHERE DateField BETWEEN @StartDate AND @EndDate"

Using connection As New OleDbConnection("connectionString")
    Using command As New OleDbCommand(query, connection)
        command.Parameters.AddWithValue("@StartDate", startDate)
        command.Parameters.AddWithValue("@EndDate", endDate)

        ' 执行查询操作
    End Using
End Using