C++CLI如何从Access数据库中的表读取数据?

您可以使用OleDb来操作Access数据库。

#include <msclr\auto_handle.h>

int main(array<System::String ^> ^args)
{
    using namespace System;
    using namespace System::Data::OleDb;

    OleDbConnection connection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\temp\\MyDatabase.accdb;Persist Security Info=False;");
    connection.Open();

    // Reading all records
    {
        msclr::auto_handle<OleDbCommand> command = connection.CreateCommand();
        command->CommandText = "select * from Table1";
        msclr::auto_handle<OleDbDataReader> reader = command->ExecuteReader();

        while (reader->Read())
        {
            Console::WriteLine(
                "ID={0}, DESCRIPTION={1}",
                reader.get()["ID"],
                reader.get()["DESCRIPTION"]);
        }
    }

    // Insert new record
    {
        msclr::auto_handle<OleDbCommand> command = connection.CreateCommand();
        command->CommandText = "insert into Table1 (ID, DESCRIPTION) values (3, 'THREE')";
        command->ExecuteNonQuery();
    }

    // Changing the DESCRIPTION field for all records
    {
        msclr::auto_handle<OleDbCommand> selectCommand = connection.CreateCommand();
        selectCommand->CommandText = "select * from Table1";
        msclr::auto_handle<OleDbDataReader> reader = selectCommand->ExecuteReader();

        while (reader->Read())
        {
            auto newDescription = reader.get()["DESCRIPTION"]->ToString();
            newDescription += " - UPDATED!";

            msclr::auto_handle<OleDbCommand> updateCommand = connection.CreateCommand();
            updateCommand->CommandText =  "update Table1 set DESCRIPTION=? where ID=?";
            updateCommand->Parameters->AddWithValue("DESCRITPION", newDescription);
            updateCommand->Parameters->AddWithValue("ID", reader.get()["ID"]);
            updateCommand->ExecuteNonQuery();
        }
    }

    return 0;
}