d153.bmp.txt

Visual C++通信编程实例

/////洲////////////洲/
                      m_pRecordsetQuery.CreateInstance(_uuidof(Recordset》 ;
     m_pRecordsetQuery->Open(str.AllocSysString0, .
theApp.m_pConnection.GetlnterfacePtr(),
  adOpenDynamic,
  adLockOptimistic,
   adCmdText);
       CString strName,strSex,strAge;
if( !m_pRecordsetQuery->BOF)
    m_pRecordsetQuery->MoveFirst0;
else
f
    AfxMessageBox(”表内数据为空”)；
    return;
)
m_Data.DeleteAllltems();
_variant_t var,
int i = 0;
try
{
 while( ! m_pRecordsetQuery->adoEOF)
 {
                       vapm_pRecordsetQuery->GetCollect( "name");
if(var.vt!=VT_NULL)
               strName = (LPCSTR)_bstr_t(var);
                       var=m_pRecordsetQuery->GetCollect( " sex ");
                  if(var.vt ! =VT_NULL)
          ,    strSex = (LPCSTR)_bstr_t(var);
                       var=m_pRecordsetQuery->GetCollect( " age ");
if(var.vt!=VT_NULL)
                                    strAge.Format( " % d",var.intVal);
m_Data.Insertltem(i,strName);
                      m_Data.SetltemText(i,l,strS ex) ;
m_Data.SetItemText(i,2,strAge);
    m_pRecordsetQuery->MoveNext0;
    i++;
    )
)
catch(_com_error &e)
{
    AfxMessageBox(“读取用户信息表内数据失败！”)；
153