ado.h

一个用来学习用的ADO类 有一定得实用价值哦

#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF" ,"adoEOF")
#include "Picture.h"

class ado
{
public:
	_ConnectionPtr m_pConnection;
	_RecordsetPtr m_pRecordset;
	CPicture m_Pic;
	CWnd m_MyWnd;
public:
 	long GetLongValue(CString FileName);
	float GetFloatValue(CString FileName);
	int GetIntValue(CString FileName);
	COleDateTime GetTimeValue(CString FileName);
	 void SetFloatValue(CString FileName,CString MyValue);
	void SetIntValue(CString FileName,CString MyValue);
	CPicture GetJPG(CWnd *p,CString FileName);
	HBITMAP GetPicture(CWnd *p, CString FileName);
	
	void SetPicture(CString FileName,CString FilePathName);
	void SetTimeValue(CString FileName,COleDateTime MyTime);
	ado();
	virtual ~ado();
	void close();
//	bool Move(int nRecordNumber);
	bool MovePrevious();
	bool MoveLast();
	bool MoveNext();
	bool MoveFirst();
	int GetRecordCount();
	//void Open(CString TSQL);
	bool Open(CString srecordset, UINT adCmd);
	void GetErrors(_com_error eErrors);
	CString GetFieldValue(CString Field);
	void AddNew();
	void Update();
	bool Move(int nRecordNum);
	void SetFieldValue(CString OField,CString value);
	void ExecuteSQL(CString SQL);
	bool recordeof();
	bool recordbof();
	void rstOpen(CString TSQL);

};