[OLE DB] Добавление ComboBoxColumn через адаптер и источник данных в dataGridView - C/C++ - Ответ 6804104

    OleDb::OleDbConnection ^ connection;
    OleDb::OleDbDataAdapter ^ autoAdapter;
 
    OleDb::OleDbDataAdapter ^ PrepareSpendingsAdapter() {
            OleDb::OleDbDataAdapter ^ adapter;
 
            adapter = gcnew OleDb::OleDbDataAdapter("SELECT * FROM table_data", connection);
            adapter->TableMappings->Add("Table", "table_data");
 
            return adapter;
    }
 
    void test()
    {
            connection = gcnew OleDb::OleDbConnection(
                "Data Source=\"..\\my_database.mdb\";User " +
                "ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
 
            DataSet ^ cachedData = gcnew DataSet();
 
            DataGridViewComboBoxColumn ^ cmb = gcnew DataGridViewComboBoxColumn();
            OleDb::OleDbDataAdapter ^ adapterSpendCategory = gcnew OleDb::OleDbDataAdapter("SELECT name FROM table_codes", connection);
            adapterSpendCategory->TableMappings->Add("Table", "table_codes");
            adapterSpendCategory->Fill(cachedData);
            cmb->DataSource = cachedData->Tables["table_codes"];
            cmb->DisplayMember = "name";
            cmb->ValueMember = "name";
 
 
            autoAdapter = PrepareSpendingsAdapter();
            // ...
            autoAdapter->Fill(cachedData);
            dataGridView1->DataSource = cachedData->Tables["table_data"];
    }