www.pudn.com > Wgl.rar > WglRecordset.cpp

// WglRecordset.cpp: implementation of the WglRecordset class. 
// 
////////////////////////////////////////////////////////////////////// 
 
#include "stdafx.h" 
#include "Wgl.h" 
#include "WglRecordset.h" 
 
#ifdef _DEBUG 
#undef THIS_FILE 
static char THIS_FILE[]=__FILE__; 
#define new DEBUG_NEW 
#endif 
 
////////////////////////////////////////////////////////////////////// 
// Construction/Destruction 
////////////////////////////////////////////////////////////////////// 
 
WglRecordset::WglRecordset() 
{ 
   
} 
WglRecordset::WglRecordset(_ConnectionPtr m_pConn) 
{ 
	m_pRecordset.CreateInstance(__uuidof(Recordset));  
 	m_pConnection=m_pConn; 
	Flag = TRUE; 
 
} 
WglRecordset::~WglRecordset() 
{ 
   
} 
BOOL  WglRecordset::GetConnection(_ConnectionPtr m_pConn) 
{ 
	m_pRecordset.CreateInstance(__uuidof(Recordset)); //COM接口 
	if( Flag == FALSE) 
	{ 
		m_pConnection	= m_pConn;		 
		Flag = TRUE; 
	} 
	return TRUE; 
} 
 
 
BOOL WglRecordset::GetRecordset(CString  strTable) 
{ 
	if( Flag == FALSE) return FALSE; 
 
 
	try 
	{ 
		m_pRecordset->Open((LPCTSTR)strTable, _variant_t((IDispatch *) m_pConnection,true), adOpenDynamic, adLockOptimistic, adCmdUnknown); 
	} 
	catch(_com_error *e) 
	{ 
		AfxMessageBox(e->ErrorMessage()); 
	}       
	return TRUE; 
} 
 
void WglRecordset::SenddataToList(CListBox * pList) 
{ 
    _variant_t var; 
    CString strName, strAge; 
   try 
	{ 
		if(!m_pRecordset->BOF) 
			m_pRecordset->MoveFirst(); 
		else 
		{ 
			AfxMessageBox("表内数据为空"); 
			return; 
		} 
 
		// 读入库中各字段并加入列表框中 
		while(!m_pRecordset->adoEOF) 
		{ 
			var = m_pRecordset->GetCollect("NAME"); 
			if(var.vt != VT_NULL) 
				strName = (LPCSTR)_bstr_t(var); 
			var = m_pRecordset->GetCollect("AGE"); 
			if(var.vt != VT_NULL) 
				strAge = (LPCSTR)_bstr_t(var); 
 
			pList->AddString( strName + " --> "+strAge ); 
			m_pRecordset->MoveNext(); 
		} 
	} 
	catch(_com_error *e) 
	{ 
		AfxMessageBox(e->ErrorMessage()); 
	}      
 
}