activecommandx.h

visual c++ 很全的ado的sample

#include "icrsint.h"


// This Class extracts id, fname, lname from authors table.

class CAuthorsRs : public CADORecordBinding
{
BEGIN_ADO_BINDING(CAuthorsRs)
    
	// Column au_id is the 1st field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, m_au_id, 
         sizeof(m_au_id), lau_idStatus, TRUE)

	// Column au_fname is the 2nd field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(2, adVarChar, m_au_fname, 
         sizeof(m_au_fname), lau_fnameStatus, TRUE)
	
	// Column au_lname is the 3rd field in the recordset   
	ADO_VARIABLE_LENGTH_ENTRY2(3, adVarChar, m_au_lname, 
         sizeof(m_au_lname), lau_lnameStatus, TRUE)
	
END_ADO_BINDING()

public:

   char 	m_au_id[21];
   ULONG	lau_idStatus;
   char 	m_au_fname[41];
   ULONG	lau_fnameStatus;
   char 	m_au_lname[41];
   ULONG	lau_lnameStatus;

};