#import "C:\Program Files (x86)\Common Files\System\ado\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
#include <cstdio>
#include <iomanip>
#include <iostream>
using namespace std;
int main(int argc, char **argv)
{
::CoInitialize(NULL);
_RecordsetPtr m_pRecordset("ADODB.Recordset");
_ConnectionPtr m_pConnection("ADODB.Connection");
_bstr_t bstrSQL("select * from Employee");
try
{
m_pConnection.CreateInstance("ADODB.Connection");
_bstr_t strConnect= "Provider=SQLOLEDB;Server=Justice-PC\\SQLEXPRESS; Database=mydatabase;
uid=justicedb; pwd=justicedb;";
m_pConnection->Open(strConnect,"","",adModeUnknown);
if(m_pConnection==NULL) cout<<"Link data ERROR!\n";
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
_variant_t name;
while(!m_pRecordset->EndOfFile)
{
name = m_pRecordset->GetCollect("EnployeeName");
if (name.vt != VT_NULL)
{
cout.setf(ios::left);
cout<<setw(14)<<(char*)(_bstr_t)name<<endl;
}
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
catch(_com_error e)
{
cout<<"ERROR!"<<endl;
}
if(m_pConnection->State) m_pConnection->Close();
::CoUninitialize();
cout<<"We Stop!"<<endl;
getchar();
return 1;
}