MFC CRecordset

MFC-CRecordset-example.cpp

void func() {
 	CDatabase db;
	CRecordset rs(&db);
	db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\dbo.mdb;");

	db.ExecuteSQL("select * from Sporter");

	rs.Open(CRecordset::dynaset, "select * from [Sporter]", CRecordset::none);

	BOOL a = rs.CanAppend();

	CDBVariant varValue;

	int count = 0;

	int nFields = rs.GetODBCFieldCount();
	while (!rs.IsEOF())
	{
	   for (int index = 0; index < nFields; index++)
	   {
		  rs.GetFieldValue(index, varValue);
		  // do something with varValue
	   }
	   rs.MoveNext();
	   count++;
	}


	rs.Close();

	db.Close();
}