CDatabase db;
db.OpenEx( _T( "DSN=orcl;UID=system;PWD=root" ));
CRecordset rs( &db );
rs.Open( CRecordset::forwardOnly,_T( "SELECT * FROM student" ) );
CDBVariant varValue;
short nFields = rs.GetODBCFieldCount( );
std::cout<<"nFields "<
<
while( !rs.IsEOF( ) )
{
for( short index = 0; index < nFields; index++ )
{
rs.GetFieldValue( index, varValue );
if(varValue.m_dwType==DBVT_ASTRING )
{
std::cout<<*varValue.m_pstringA<
}
if(varValue.m_dwType==DBVT_WSTRING )
{
_tprintf(_T("%s/n"),*varValue.m_pstringW);
}
}
rs.MoveNext( );
}