C / C++ / MFC

pCommand->CommandText="INSERT INTO tblTest (Color, Texture) VALUES ('navy blue', 'rusty') "; 
_RecordsetPtr pRecordset; 

hr = pRecordset.CreateInstance (__uuidof (Recordset)); 

if (FAILED (hr)) 
{ 
AfxMessageBox ("Can't create an instance of Recordset"); 
return; 
} 
AfxMessageBox("LLL"); 

pRecordset->CursorLocation = adUseClient; 
pRecordset->Open ((IDispatch *) pCommand, vtMissing, adOpenDynamic, adLockBatchOptimistic, adCmdTable); 

	{
		_CommandPtr pCommand;

		HRESULT hr = pCommand.CreateInstance (__uuidof (Command));

		if (FAILED (hr))
		{
			AfxMessageBox ("Can't create an instance of Command");
			return;
		}

		pCommand->ActiveConnection = m_pConn;
	pCommand->CommandText="SELECT * FROM tblTest ";//Where (Shape = 'triangle' Or Shape ='round' ) AND (Color='red' Or Color = 'green')";//Where (Color = red Or Color = green) "));
//	pCommand->CommandText="SELECT Shape, Color, Texture FROM tblTest Where (Shape = 'triangle' Or Shape ='round' ) AND (Color='red' Or Color = 'green')";//Where (Color = red Or Color = green) "));

		_RecordsetPtr pRecordset;

		hr = pRecordset.CreateInstance (__uuidof (Recordset));

		if (FAILED (hr))
		{
			AfxMessageBox ("Can't create an instance of Recordset");
			return;
		}

		pRecordset->CursorLocation = adUseClient;
		pRecordset->Open ((IDispatch *) pCommand, vtMissing, adOpenStatic,
							adLockBatchOptimistic, adCmdUnknown);
		CString strContent;

		CString numRec;

		long num =pRecordset->RecordCount;
		numRec.Format("number of records is %d ",num);
		AfxMessageBox(numRec);


pRecordset->AddNew();

pRecordset->Fields->GetItem("Color")->Value = "orange";
pRecordset->Fields->GetItem("Texture")->Value = "fuzzy";
	
			pRecordset->UpdateBatch (adAffectAll);
			pRecordset->Close ();

	}

CADORecordset::CADORecordset(CADODatabase* pAdoDatabase)
{
	m_pRecordset = NULL;
	m_pCmd = NULL;
	m_strQuery = _T("");
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pCmd.CreateInstance(__uuidof(Command));
	m_nEditStatus = CADORecordset::dbEditNone;
	m_nSearchDirection = CADORecordset::searchForward;
	
	m_pConnection = pAdoDatabase->GetActiveConnection();
}

_RecordsetPtr m_pRecordset;