//从数据库中读取信息
CString strSQL,strframeid,strframename,strstatus;
_RecordsetPtr m_pRecordset; 

if (FAILED(m_pRecordset.CreateInstance("ADODB.Recordset")))
{
AfxMessageBox("Create Instance failed!");
return ;
}
strSQL = "select * from t_frame";
_variant_t varSQL(strSQL);
if(FAILED(m_pRecordset->Open(varSQL,(app->m_pConnection).GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText)))
{
AfxMessageBox("Open table failed!");
m_pRecordset.Release();
return;
}
int recordcount=m_pRecordset->GetRecordCount(); if(recordcount!=0)
{
while(!m_pRecordset->adoEOF)
{
strframeid.Format((_bstr_t)m_pRecordset->GetCollect("frame_id"));
strframename.Format((_bstr_t)m_pRecordset->GetCollect("frame_name"));
strId[i]=strframeid;
strName[i]=strframename;
m_pRecordset->MoveNext();
i++;
}
}
m_pRecordset.Release();