使用CDatabase类读取Access数据库

//以下是主要代码
void CReadDBDlg::OnRead()
{
 // TODO: Add your control notification handler code here

 CDatabase database;
 CString SqlString;
 CString sCatID, sCategory;
 CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
 CString sDsn;
 CString sFile = "c://works//ReadDB//Test.mdb";//Change path here
 int iRec = 0; 
 
 // Create ODBC connection dinamically
 sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
 TRY
 {
  // Open the database
  database.Open(NULL,false,false,sDsn);
 
  // Allocate the recordset
  CRecordset recset( &database );

  // Build the SQL statement
  SqlString =  "SELECT CatID, Category "
    "FROM Categories";

  // Execute the query
  recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
  ResetListControl();
 
  // Column width and heading
  m_ListControl.InsertColumn(0,"Cat ID",LVCFMT_LEFT,-1,0);
  m_ListControl.InsertColumn(1,"Category",LVCFMT_LEFT,-1,1);
  m_ListControl.SetColumnWidth(0, 70);
  m_ListControl.SetColumnWidth(1, 200);

  // Loop through each record
  while( !recset.IsEOF() )
  {
   // Copy each column into a variable
   recset.GetFieldValue("CatID",sCatID);
   recset.GetFieldValue("Category",sCategory);

   // Insert values into the list control
   iRec = m_ListControl.InsertItem(0,sCatID,0);
   m_ListControl.SetItemText(0,1,sCategory);

   // goto next record
   recset.MoveNext();
  }
  // Set column width
  //m_ListControl.SetColumnWidth(0, LVSCW_AUTOSIZE);
  //m_ListControl.SetColumnWidth(1, LVSCW_AUTOSIZE);
  // Close the database
  database.Close();
 }
 CATCH(CDBException, e)
 {
  // If a database exception occured, show error msg
  AfxMessageBox("Database error: "+e->m_strError);
 }
 END_CATCH;
}
 

void CReadDBDlg::ResetListControl()
{
 m_ListControl.DeleteAllItems();
 int iNbrOfColumns;
 CHeaderCtrl* pHeader = (CHeaderCtrl*)m_ListControl.GetDlgItem(0);
 if (pHeader)
 {
  iNbrOfColumns = pHeader->GetItemCount();
 }
 for (int i = iNbrOfColumns; i >= 0; i--)
 {
  m_ListControl.DeleteColumn(i);
 }
}