C / C++ / MFC

includeh10 wrote:

hope someone kown my questions.

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

includeh10 wrote:

I just saw many traffic from code-project to my site on the second day after modification.

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

//example from MSDN
CRecordSet rs;
// Open the recordset
rs.Open( CRecordset::dynaset, NULL,
         CRecordset::useMultiRowFetch );

// loop through the recordset by rowsets
while( !rs.IsEOF( ) )
{
    for( int rowCount = 0; 
         rowCount < (int)rs.GetRowsFetched( );
         rowCount++ )
    {
       // do something
      //you must be adding values from result to list control
    }

   rs.MoveNext( );
}

rs.Close( );

// Open the recordset
rs.Open( CRecordset::dynaset, NULL,
         CRecordset::useMultiRowFetch );
rs.Open( CRecordset::dynaset,
         _T( "Select count(*) from Tablename" ) );//I dont know exact query //but , it gives row count in table

//now instead of travesing record set
    for( int rowCount = 0; 
         rowCount < (int)rs.GetRowsFetched( );
         rowCount++ )
    {
       // do something
      //fill list control with empty rows
    }