I program between VC and ACCESS. Use CListView to show a *.mdb content.
look thisto get room_name by room_id in a table)
//============================================
m_strTableName = _T("room");
strSelect = _T("Select room_ID,room_name From [");
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF()) {
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
StuffDlg.m_uaRoom.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
StuffDlg.m_saRoom.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
//============================================
!! StuffDlg.m_saRoom is a CStringArray.

what is the meaning and usage of COleVariant.The explanation in MSDN is too abstract!!
who can give me a simple example?