ADO Wrapper Classes

Environment: VC6 SP4, NT4 SP6

Acknowledgements

This article is based in part on Bob Place’s
ADO is AOK (a simple ADO tutorial).

Wrapper Usage

This is consist of 2 classes.

  • CDyndb : This Class manages connections and recordsets. Recordsets are organized as linked list (CList) and you can access them using their ids.
  • CDynRec : This class is the node to populate for each recordsets.

Simply follow these steps in order to use the ADO wrapper classes:

  1. You need to add the following line stdafx.h :
  2. #import "c:program filescommon filessystemadomsado21.tlb" no_namespace rename ("EOF", "adoEOF")
    
  3. Call the OpenConn function

    theApp.m_dyndb.OpenConn(“driver=sql server;server=dogu;UID=sa;PWD=;database=dbtraining;”);

  4. Call OpenRec function
  5. theApp.m_dyndb.OpenRec("select * from Courses");
    
  6. Call GetFieldVal function to get the value of the fields. This function returns variant type.
    You can cast it as usual way like “short(variantdata);”
  7. vardat=theApp.m_dyndb.GetFieldVal(0,2);
    
  8. Call GetFieldType to get the type of the field. “en” has a definition like
    DataTypeEnum en; (see MSDN for details)
  9. en=theApp.m_dyndb.GetFieldType(0,2);
    
  10. Call GetFieldCount to get the number of the fields that selected in the recordset.

  11. Call GetFieldName to obtain the name of the field.

To iterate through a recordset, you can use the m_pRecordSet member functions MoveXXX.

Downloads

Download source – 2 Kb

Download demo project – 121 Kb

More by Author

Must Read