dbconnection.h

动态连接ODBC数据库.使用通过数据源的名称动态链接访问ODBC数据库

#ifndef DBConnection_H
#define DBConnection_H


#include "Bulkset.h"
#include "DynamicRow.h"
#include "DBField.h"
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

class CDBConnection : public CObject
{


public :
	
	BOOL PrepareFieldExchange();
	BOOL UpdateRow(CString sTable);
	BOOL DeleteRow(CString sTable);
	BOOL AddNewRow(CString sTable);
	
	CString GetFieldValue(int nField);
	CString m_sConnectedDSN;
	CTypedPtrArray<CObArray, CDBField*> m_pFields;

	CDynamicBulkSet *m_pResultSet;
	CDynamicRow *m_pDynamicRow;
	int m_nCurRow;
	int m_nNumFields;
	CDatabase m_DataBase;


	CDBConnection();
	~CDBConnection();


	CString GetNextRow();
	BOOL ExecuteStatement(CString SqlStmt);
	BOOL ConnectToDataBase(CString DSN,CString sUser,CString sPassword,BOOL UseLogonDlg);


};//class CDBConnection

#endif //DBConnection_H