C / C++ / MFC

<br />
/*<br />
	Database Console Application<br />
*/<br />
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \<br />
no_namespace rename("EOF", "EndOfFile")<br />
<br />
#include <stdio.h><br />
#include <iostream><br />
using namespace std;<br />
<br />
void main(void)<br />
{<br />
	string sMovie = "Vertigo";<br />
	<br />
    CoInitialize(NULL);<br />
    try <br />
    {<br />
        _RecordsetPtr pRst("ADODB.Recordset");<br />
        // Connection String<br />
        _bstr_t strCnn("DRIVER={Microsoft Access Driver (*.mdb)};UID=admin;DBQ=VideoRental.mdb");<br />
     	// Open table<br />
		<br />
		pRst->Open("SELECT * FROM [Video] WHERE [Video].[PROD_Title] = 'Vertigo';", strCnn, adOpenStatic, adLockReadOnly, adCmdText);<br />
        	 <br />
	   	pRst->MoveFirst();<br />
<br />
   		while (!pRst->EndOfFile) <br />
		{<br />
			cout<<(char*) ((_bstr_t) pRst->GetFields()->GetItem("PROD_ID")->GetValue())<< " ";<br />
			cout<<(char*) ((_bstr_t) pRst->GetFields()->GetItem("PROD_TITLE")->GetValue())<< " ";<br />
            pRst->MoveNext();<br />
        }<br />
		system("pause");<br />
        pRst->Close();<br />
<br />
		system("pause");<br />
            	 <br />
	}<br />
    catch (_com_error &e)<br />
    {<br />
		cout<<(char*) e.Description();<br />
    }<br />
    <br />
	::CoUninitialize();<br />
}<br />