Click here to Skip to main content
15,867,308 members
Articles / Desktop Programming / MFC

Using the CDatabase class to read an Access databases

Rate me:
Please Sign up or sign in to vote.
4.71/5 (41 votes)
29 Mar 2001 362.1K   6.3K   68   91
This is a very simple code snippet that demonstrates how to read a Microsoft Access database file using the CDatabase class

Sample Image - ReadDB.gif

Introduction

This is a very simple code snippet that demonstrates how to read a Microsoft Access database using the CDatabase class.

The main features it demonstrates are:

  • Retrieving data from Microsoft Access database
  • Connecting without the need for an ODBC data source to be set up.
  • Populate a List view Control with the data
//
// Part of the source code
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 = "d:\\works\\ReadDB\\Test.mdb";
	// You must change above path if it's different
	int iRec = 0; 	
	
	// Build ODBC connection string
	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);
		// Reset List control if there is any data
		ResetListControl();
		// populate Grids
		ListView_SetExtendedListViewStyle(m_ListControl,LVS_EX_GRIDLINES);
 
		// Column width and heading
		m_ListControl.InsertColumn(0,"Category Id",LVCFMT_LEFT,-1,0);
		m_ListControl.InsertColumn(1,"Category",LVCFMT_LEFT,-1,1);
		m_ListControl.SetColumnWidth(0, 120);
		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();
		}
		// Close the database
		database.Close();
	}
	CATCH(CDBException, e)
	{
		// If a database exception occured, show error msg
		AfxMessageBox("Database error: "+e->m_strError);
	}
	END_CATCH;
}
	
// Reset List control
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);
	}
}

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
Questionx64? Pin
gok20-Dec-16 4:38
professionalgok20-Dec-16 4:38 
QuestionCharacter truncation if switching to Unicode in Memo fields Pin
dlavrantonis15-Oct-13 4:11
dlavrantonis15-Oct-13 4:11 
Questionconnect to mdf sql database Pin
Mahdi Nejadsahebi20-Dec-12 0:26
Mahdi Nejadsahebi20-Dec-12 0:26 
QuestionUsing the CDatabase class to read an Access databases-->write Pin
Member 942749014-Sep-12 21:13
Member 942749014-Sep-12 21:13 
GeneralMy vote of 5 Pin
Mahdi Nejadsahebi27-Apr-12 19:15
Mahdi Nejadsahebi27-Apr-12 19:15 
GeneralError messages in running Using the CDatabase class to read an Access databases Pin
shiphy21-Mar-10 20:03
shiphy21-Mar-10 20:03 
GeneralRe: Too much in Try/Catch [modified] Pin
shiphy19-Mar-10 11:15
shiphy19-Mar-10 11:15 
GeneralToo much in Try/Catch Pin
William Winner19-Mar-10 9:49
William Winner19-Mar-10 9:49 
GeneralHaving problems showing data in my Access Database in the List Control Pin
shiphy19-Mar-10 9:18
shiphy19-Mar-10 9:18 
GeneralDatabase Error [modified] Pin
S p k 52129-Jun-08 19:24
S p k 52129-Jun-08 19:24 
GeneralRe: Database Error Pin
zhaque3-Feb-10 14:00
zhaque3-Feb-10 14:00 
GeneralDataBase Error Pin
S p k 52129-Jun-08 19:22
S p k 52129-Jun-08 19:22 
GeneralThank you very much Pin
Jellow TK27-Feb-08 8:49
Jellow TK27-Feb-08 8:49 
QuestionHow to use Other databases Like "SQL"" Pin
rag84dec21-May-07 20:27
rag84dec21-May-07 20:27 
QuestionRe: Multiple table help, please? Pin
mla15427-Feb-07 6:08
mla15427-Feb-07 6:08 
QuestionAccess file creation Pin
Arun M S17-Jan-07 18:28
Arun M S17-Jan-07 18:28 
QuestionIn modal dglboxes? Pin
swapna_signsin11-May-06 0:22
swapna_signsin11-May-06 0:22 
Generalc/c++ with sql/access database Pin
Anonymous5-Oct-05 22:35
Anonymous5-Oct-05 22:35 
Generalunresolved external symbol Pin
WinAPILearner31-Oct-04 11:44
WinAPILearner31-Oct-04 11:44 
GeneralRe: unresolved external symbol Pin
Anonymous18-Feb-05 10:46
Anonymous18-Feb-05 10:46 
GeneralRe: unresolved external symbol Pin
zhaque31-Oct-05 7:25
zhaque31-Oct-05 7:25 
GeneralBound error Pin
vivadot18-Oct-04 11:24
vivadot18-Oct-04 11:24 
AnswerRe: Bound error Pin
liuxiaop12-Feb-07 2:43
liuxiaop12-Feb-07 2:43 
Generaldatabase + listcontrol Pin
sakesh16-Sep-04 20:50
sakesh16-Sep-04 20:50 
QuestionUnicode? Pin
Badaa25-Apr-04 2:19
Badaa25-Apr-04 2:19 
GetFieldValue supports Unicode?
I have some unicode data in my database. After this function call ( GetFieldValue("Descript",sDescript) I get always "??????" characters. For debugging I have used
fout << (const char*) sDescript << endl;

tnx

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.