C / C++ / MFC

#pragma once<br />
#include afxdb.h<br />
<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 />
};

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 + "WD=" + 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 />
}