C / C++ / MFC

#pragma once<br />
#include <afxwin.h><br />
#include <afxdb.h><br />
<br />
class AFX_EXT_CLASS SRecordset : public CObject<br />
{<br />
	DECLARE_SERIAL(SRecordset)<br />
<br />
<br />
public:<br />
	SRecordset(void);<br />
		<br />
public:<br />
	~SRecordset(void);<br />
<br />
protected:<br />
	CStringArray saDataContainer; <br />
    short iNumFldCount; <br />
	long iNumRec; <br />
	int iRecCount; <br />
	int iTotalSize; <br />
	int iRecordState; <br />
	int iLocalIndex; <br />
public:<br />
	BOOL SSOpen(CDatabase &dbConnectedObj,CString sQuery); <br />
	BOOL SSIsOpen(void); <br />
	void SSClose(void);  <br />
public:<br />
	BOOL SSIsBOF(void); <br />
	BOOL SSIsEOF(void); <br />
public:<br />
	void SSGetFieldValue(int iIndex,CString &FldValue); <br />
	short SSGetFieldCount(void); <br />
	long SSGetRecordCount(void); <br />
	long SSGetCurrentRecordCount(void); <br />
public:<br />
	void SSMoveNext(void); <br />
	void SSMovePrevious(void); <br />
	void SSMoveFirst(void); <br />
	void SSMoveLast(void); <br />
public:<br />
	virtual void Serialize(CArchive& ar); <br />
};<br />

void CtestingDlg::OnBnClickedOk()<br />
{<br />
	// TODO: Add your control notification handler code here<br />
<br />
<br />
	CDatabase db;<br />
	CString sIp,sDb,sPwd,sConn,sPort,sUn;<br />
	sIp="192.168.2.17";<br />
	sPort="5432";<br />
	sPwd="fasp";<br />
	<br />
<br />
	try<br />
	{		<br />
	 sConn = "DRIVER={PostgreSQL ANSI};SERVER=" + sIp + ";port=" +          <br />
          sPort + ";DATABASE=" + sPwd + ";UID=" + sPwd + ";PWD=" + sPwd + ";";<br />
	 db.OpenEx(sConn);<br />
	 AfxMessageBox("Success");<br />
	}<br />
	catch(CDBException *e)<br />
	{<br />
	 MessageBox("Database Connection Refused."+e->m_strError,"DataBase  <br />
          Connection Error",MB_OK|MB_ICONERROR);<br />
	 e->Delete();<br />
		<br />
	}<br />
<br />
<br />
	SRecordset set1;<br />
<br />
	set1.SSOpen(db,"select name from master;");<br />
        set1.SSGetFieldCount();<br />
	set1.SSGetRecordCount();<br />
	set1.SSClose();<br />
<br />
	OnOK();<br />
}<br />