如何使用VB.NET和MS ACCESS将数据从最新记录到最旧记录排序

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;"

        Using connection As New OleDbConnection(connectionString)
            connection.Open()

            Dim query As String = "SELECT * FROM TableName ORDER BY DateField DESC"

            Using command As New OleDbCommand(query, connection)
                Using reader As OleDbDataReader = command.ExecuteReader()
                    While reader.Read()
                        ' 获取每一条记录的数据
                        Dim field1 As String = reader.GetString(0)
                        Dim field2 As Integer = reader.GetInt32(1)
                        ' ...

                        ' 处理数据...
                    End While
                End Using
            End Using
        End Using
    End Sub
End Class