C / C++ / MFC

<br />
#include <windows.h><br />
#include <stdio.h><br />
#include <iostream.h><br />
<br />
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \<br />
no_namespace rename("EOF", "EndOfFile")<br />
<br />
void main(int argc, char* argv[])<br />
{<br />
<br />
HRESULT hr = S_OK;<br />
_ConnectionPtr m_pConn;<br />
    try<br />
	{<br />
		HRESULT hr = m_pConn.CreateInstance(__uuidof(Connection));<br />
		if (FAILED( hr ))<br />
			cout<<"Can't create an intance of ADO.Connection"<<endl;<br />
 <br />
		if (FAILED( m_pConn->Open(_bstr_t("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =ADOTestDB.MDB"),<br />
			_bstr_t( "" ),<br />
			_bstr_t( "" ), <br />
			adModeUnknown )))<br />
			<br />
			cout<<"Can't open datasource"<<endl;<br />
<br />
<br />
		_CommandPtr pCommand;<br />
		pCommand.CreateInstance (__uuidof (Command));<br />
		pCommand->ActiveConnection = m_pConn; <br />
		pCommand->CommandText = "Select Name,Dept From Student";<br />
		_RecordsetPtr pRecordset;<br />
		pRecordset.CreateInstance (__uuidof (Recordset));<br />
		pRecordset->CursorLocation = adUseClient;<br />
		pRecordset->Open ( (IDispatch *) pCommand, vtMissing, adOpenStatic,<br />
		adLockBatchOptimistic, adCmdUnknown);<br />
<br />
		_bstr_t valField1;<br />
		int valField2;<br />
		pRecordset->MoveFirst();<br />
		if (!pRecordset->EndOfFile)<br />
		{<br />
			while(!pRecordset->EndOfFile)<br />
			{<br />
			valField1 = pRecordset->Fields->GetItem("Name")->Value;<br />
			valField2 = pRecordset->Fields->GetItem("Dept")->Value.intVal;<br />
				printf("%d - %s\n",valField2,(LPCSTR)valField1);<br />
				pRecordset->MoveNext();<br />
			}<br />
		}<br />
<br />
		<br />
	}catch( _com_error &ce )<br />
	{<br />
		printf("Error:%s\n",ce.Description);<br />
<br />
	}<br />
	m_pConn->Close();<br />
<br />
}<br />