.mdb文件读写方法
Stdafx.h文件中加入
#import "c:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","rsEOF")
::OnInitDialog()函数中加入
m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,
CRect(10,10,400,200), this, 1);
m_ListCtrl.InsertColumn(0,"用户名",LVCFMT_CENTER,80);
m_ListCtrl.InsertColumn(1,"密码",LVCFMT_CENTER,76);
m_ListCtrl.InsertColumn(2,"ID",LVCFMT_CENTER,80);
void Cmdb::OnOK()
{
// TODO: Add extra validation here
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
char* db="datatest.mdb";
pConn->ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
pConn->ConnectionString+=db;
pConn->Open("","","",adConnectUnspecified);
pRst=pConn->Execute("select * from admin",NULL,adCmdText);
while(!pRst->rsEOF)
{
int nRow = m_ListCtrl.InsertItem(0, (_bstr_t)pRst->GetCollect("用户名"));
m_ListCtrl.SetItemText(nRow,1, (_bstr_t)pRst->GetCollect("密码"));
m_ListCtrl.SetItemText(nRow,2, (_bstr_t)pRst->GetCollect("ID"));
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
pRst.Release();
pConn.Release();
CoUninitialize();
}