CODBCAccess: a CDatabase and CRecordset Wrapper

// ViewSet.cpp : implementation file
//

#include "stdafx.h"
#include "ODBCExample.h"
#include "ViewSet.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CViewSet dialog


CViewSet::CViewSet(CWnd* pParent /*=NULL*/)
	: CDialog(CViewSet::IDD, pParent)
{
	//{{AFX_DATA_INIT(CViewSet)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CViewSet::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CViewSet)
	DDX_Control(pDX, IDC_SET, m_ctlSet);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CViewSet, CDialog)
	//{{AFX_MSG_MAP(CViewSet)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CViewSet message handlers

BOOL CViewSet::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//Set general list control properties:
	m_ctlSet.SetExtendedStyle(LVS_EX_FULLROWSELECT);

	//Move set to beginning:
	if(!set->IsBOF())
		set->MoveFirst();

	//Some temps:
	long cols = set->GetODBCFieldCount();
	CODBCFieldInfo info;
	CString item;

	//Loop through to add each column:
	for(int h = 0; h < cols; h++)
	{
		//Add this item:
		set->GetODBCFieldInfo(h, info);
		m_ctlSet.InsertColumn(h, info.m_strName, LVCFMT_LEFT, 100, h);
	}

	//Now add row information:
	for(h = 0; h < set->GetRecordCount(); h++)
	{
		//Insert an item for this:
		m_ctlSet.InsertItem(1, h, "", 0, 0, 0, NULL);

		//Loop through to set text for this row:
		for(int j = 0; j < cols; j++)
		{
			set->GetFieldValue(j, item);
			m_ctlSet.SetItem(h, j, LVIF_TEXT, item, 0, 0, 0, NULL);
		}

		//Move to the next record:
		set->MoveNext();
	}

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}