如何用CRecordset类来数据库表的数据

[mybcb]

我新建立了一个类，继承CDatabase，如何通过CRecordset类为取得SQL Server的表的数据呢(如表t_user)。

[zhjie374]

似乎任何的数据库书上都有讲吧!
方法很多

[笨笨兔兔兔兔兔]

// Create and open a database object;
// do not load the cursor library
CDatabase db;
db.OpenEx( NULL, CDatabase::forceOdbcDialog );

// Create and open a recordset object
// directly from CRecordset. Note that a
// table must exist in a connected database.
// Use forwardOnly type recordset for best
// performance, since only MoveNext is required
CRecordset rs( &db );
rs.Open( CRecordset::forwardOnly,
_T( "SELECT * FROM SomeTable" ) );

// Create a CDBVariant object to
// store field data
CDBVariant varValue;

// Loop through the recordset,
// using GetFieldValue and
// GetODBCFieldCount to retrieve
// data in all columns
short nFields = rs.GetODBCFieldCount( );
while( !rs.IsEOF( ) )
{
for( short index = 0; index < nFields; index++ )
{
rs.GetFieldValue( index, varValue );
// do something with varValue
}
rs.MoveNext( );
}

rs.Close( );
db.Close( );

[笨笨兔兔兔兔兔]

"SELECT * FROM t_user"