16,471
社区成员
发帖
与我相关
我的任务
分享
void CAdoAccessDlg::OnSearch()
{
// TODO: Add your control notification handler code here
CString strSql;
strSql.Format("select * from table1 where name = '%s'",m_Name);
BSTR bsSql = strSql.AllocSysString();
m_pRecordset->Open((CComVariant)bsSql,m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
//将查询结果在列表框中显示出来
while(VARIANT_FALSE == m_pRecordset->EndOfFile)
{
_variant_t vFieldValue;
CString strName,strAge;
CString strItem;
vFieldValue = m_pRecordset->GetCollect("Name");
strName = (char*)_bstr_t(vFieldValue);
vFieldValue.Clear();
vFieldValue = m_pRecordset->GetCollect("Age");
strAge = (char*)_bstr_t(vFieldValue);
vFieldValue.Clear();
strItem.Format("姓名%s 年龄%s",strName,strAge);
m_AccessList.AddString(strItem);
m_pRecordset->MoveNext();
}
}