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 />

-----------------------------------------------------------
#pragma once

// CMyLogOnDialog dialog

class CMyLogOnDialog : public CDialog
{
	DECLARE_DYNAMIC(CMyLogOnDialog)

public:
	CMyLogOnDialog(CWnd* pParent = NULL);   // standard constructor
	virtual ~CMyLogOnDialog();

// Dialog Data
	enum { IDD = LogOn_DIALOG };

protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support

	DECLARE_MESSAGE_MAP()
public:
	afx_msg void OnBnClickedButton();
};

----------------------------------------
#pragma once


// CMyMainDialog dialog

class CMyMainDialog : public CDialog
{
	DECLARE_DYNAMIC(CMyMainDialog)

public:
	CMyMainDialog(CWnd* pParent = NULL);   // standard constructor
	virtual ~CMyMainDialog();

// Dialog Data
	enum { IDD = Main_DIALOG };

protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support

	DECLARE_MESSAGE_MAP()
};

-------------------------------------------------
// MyLogOnDialog.cpp : implementation file
//

#include "stdafx.h"
#include "ECO.h"
#include "MyLogOnDialog.h"
#include "MyMainDialog.h"


// CMyLogOnDialog dialog

IMPLEMENT_DYNAMIC(CMyLogOnDialog, CDialog)

CMyLogOnDialog::CMyLogOnDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CMyLogOnDialog::IDD, pParent)
{

}

CMyLogOnDialog::~CMyLogOnDialog()
{
}

void CMyLogOnDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}


BEGIN_MESSAGE_MAP(CMyLogOnDialog, CDialog)
	ON_BN_CLICKED(LogOnOK_Button, &CMyLogOnDialog::OnBnClickedButton)
END_MESSAGE_MAP()


// CMyLogOnDialog message handlers

void CMyLogOnDialog::OnBnClickedButton()
{
	// TODO: Add your control notification handler code here
	CMyMainDialog dlg;
   dlg.DoModal();
}
 
----------------------------------------------
// MyMainDialog.cpp : implementation file
//

#include "stdafx.h"
#include "ECO.h"
#include "MyMainDialog.h"


// CMyMainDialog dialog

IMPLEMENT_DYNAMIC(CMyMainDialog, CDialog)

CMyMainDialog::CMyMainDialog(CWnd* pParent /*=NULL*/)
	: CDialog(CMyMainDialog::IDD, pParent)
{

}

CMyMainDialog::~CMyMainDialog()
{
}

void CMyMainDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}


BEGIN_MESSAGE_MAP(CMyMainDialog, CDialog)
END_MESSAGE_MAP()
----------------------------------------------------