c#将access数据库的最高id赋值给变量

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path/to/your/access/database.accdb";

string query = "SELECT MAX(ID) FROM TableName";
int maxID = 0;

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    using (OleDbCommand command = new OleDbCommand(query, connection))
    {
        connection.Open();
        maxID = (int)command.ExecuteScalar();
    }
}

int highestID = maxID;