C / C++ / MFC

CString strUrl,	  // Holds url.
	strBuff,  // Holds data collected from the opened url.
	strError; // Holds error info.
	 
// Internet session object
CInternetSession mysession;
CStdioFile* remotefile;
 
char httpbuff[4096];
int numbytes;
 
strUrl = _T("HTTP://www.someurl.com/index.htm");
strError = _T("SUCCESS");
 
TRY
{
	remotefile = mysession.OpenURL(strUrl,1,INTERNET_FLAG_TRANSFER_BINARY|INTERNET_FLAG_RELOAD);
	 	
	// Read the contents of the remote file into the temp string.
	while (numbytes = remotefile->Read(httpbuff, sizeof(httpbuff)-1))
	{
		// Null terminate the buffer..
		httpbuff[NULL];
 
		// add the contents to our temp string..
		strBuff += (CString)httpbuff;
	}
		 
	// Clean up.
	mysession.Close();
	remotefile->Close();
	delete remotefile;
}
									
// Catch any errors and format the error msg..
CATCH_ALL(error)
{
	TCHAR szCause[4096];
	error->GetErrorMessage(szCause,4096,NULL);
	strError.Format("%s",szCause);
}
END_CATCH_ALL;
									
if(!strError.CompareNoCase(_T("SUCCESS")))
{
	// Do the parsing..

}
else
{
	// Display the error..
}

CString CDBIncome::GetDefaultSQL()
{
    CString strQuery;
 
    strQuery.Format("SELECT AVG(TROL) AS MROL, AVG(TEURO) AS MEURO, AVG(TUSD) AS MUSD FROM Total WHERE date > '%s'", m_strSomeDateValue);
 
    return strQuery;
}