C / C++ / MFC

 Set rs1 = New ADODB.Recordset<br />
  <br />
 rs1.Open "select * from " & s1, con1, adOpenDynamic, adLockOptimistic<br />
 <br />
 ' Populating the created table with the values<br />
<br />
 If trs.EOF = False Then<br />
 <br />
   trs.MoveFirst<br />
 <br />
   Do While trs.EOF = False<br />
     rs1.AddNew<br />
     For i = 0 To trs.Fields.Count - 1<br />
        rs1(i) = trs(i)<br />
     Next<br />
     rs1.Update<br />
    trs.MoveNext<br />
   Loop<br />
 <br />
   MsgBox "Data entered successfully", vbInformation<br />
 End If<br />

class CDBSet : public CRecordset
{
  //code removed for brevity
  CString	m_name;
  long	m_id;

};
void CDBSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CDBSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[Field_name]"), m_name);
	RFX_Long(pFX, _T("[Field_id]"), m_id);
	//}}AFX_FIELD_MAP
}

cuongnq wrote:

I write it in VC++ is m_pRecordsetMsAccess[i]=m_pRecordsetMsSQL[i] but wrong,

rs1.AddNew( );
rs1.m_name = m_pRecordsetMsSQL.GetFieldValue(..);//get corresponding field value
rs1.m_id = m_pRecordsetMsSQL.GetFieldValue(..);//get corresponding field value
rs1.Update( );

<br />
rs1.AddNew( );<br />
rs1.m_name = m_pRecordsetMsSQL.GetFieldValue(..);//get corresponding field value<br />
rs1.m_id = m_pRecordsetMsSQL.GetFieldValue(..);//get corresponding field value<br />
rs1.Update( );<br />

<br />
theApp.m_pRecordsetSQL->AddNew();	<br />
for (int i=0 ; i<theApp.m_pRecordsetMsAccess->Fields->Count; i++)<br />
{<br />
:confused:<big><code>Help me here plz

cuongnq wrote:

So i can use your method,I want to get Recordset Object as like as RS(i). Like that:

      <br />
For i = 0 To trs.Fields.Count - 1<br />
     rs1(i) = trs(i) // With This Part, Can I write it in VC++ MFC??:confused:<br />
Next<br />