C / C++ / MFC

//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
    }

Flaviu_2006 wrote:

if are other that are more fast then afxdb.h please tell me !?

madhu_v wrote:

1)If the thread is opened and closed each time for computation, will
the program memory grow??? or what is the drawback??
OR

madhu_v wrote:

s it advisable to run the thread with sleep mode without closing the
thread??

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

<br />
#include <list><br />
using namespace std;<br />
...<br />
std::_String_base a;<br />
	a._Xran();<br />