AfxOleInit();
Type.AddString(_T("全部类型"));
Type.SetCurSel(0);
ConnectPtr.CreateInstance(__uuidof(Connection));
try
{
ConnectPtr->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=People.mdb", "", "", adModeUnknown);
}
catch (_com_error e)
{
AfxMessageBox(_T("链接数据库失败"));
return FALSE;
}
_RecordsetPtr RecordPtr;
RecordPtr.CreateInstance(__uuidof(Recordset));
try
{
RecordPtr->Open("SELECT * FROM TYPE",
ConnectPtr.GetInterfacePtr(),
adOpenDynamic,
adLockOptimistic,
adCmdText);
}
catch (_com_error *e)
{
AfxMessageBox(e->ErrorMessage());
}
_variant_t var;
CString strName;
RecordPtr->MoveFirst();
while (!RecordPtr->adoEOF)
{
var =RecordPtr->GetCollect("TYPE");
if (var.vt != VT_NULL)
{
strName = (LPCSTR)_bstr_t(var);
}
Type.AddString(strName);
RecordPtr->MoveNext();
}
RecordPtr->Close();
RecordPtr.Release();
RecordPtr = NULL;