ameStatus;

   ULONG   m_ul_lnameStatus;

};



void main(void)

{

   ::CoInitialize(NULL);

   try

      {

      _RecordsetPtr pRs("ADODB.Recordset");

      CCustomRs rs;

      IADORecordBindingPtr picRs(pRs);

      

      pRs->Open("SELECT * FROM Employee ORDER BY lname",

         "dsn=pubs;uid=sa;pwd=;",

         adOpenStatic, adLockOptimistic, adCmdText);

      

      TESTHR(picRs->BindToRecordset(&rs));



      while (!pRs->EndOfFile)

         {

      // 处理CCustomRs中的数据

         printf("Name = %s %s\n",

            (rs.m_ul_fnameStatus == adFldOK ? rs.m_ch_fname: "<Error>"),

            (rs.m_ul_lnameStatus == adFldOK ? rs.m_ch_lname: "<Error>"));



      // 移动到下一行，新行的值会被自动填充到对应的CCustomRs的变量中

         pRs->MoveNext();

         }

      }

   catch (_com_error &e )

      {

      printf("Error:\n");

      printf("Code = %08lx\n", e.Error());

      printf("Meaning = %s\n", e.ErrorMessage());

      printf("Source = %s\n", (LPCSTR) e.Source());

      printf("Description = %s\n", (LPCSTR) e.Description());

      }

   ::CoUninitialize();

}