C / C++ / MFC

HBRUSH CMyProgramView::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CFormView::OnCtlColor(pDC, pWnd, nCtlColor);
	
	INT nIDCtl = pWnd->GetDlgCtrlID();
	switch(nIDCtl)
	{
	case IDC_TEXT_BOX: 
		if (!m_strTextBox.IsEmpty())
		{
			// Change background color to white so that the
			// text is easier to read.
			pDC->SetBkColor(RGB(255, 255, 255));
			CBrush br;
			br.CreateSolidBrush(RGB(255, 255, 255));
			hbr = (HBRUSH)br;
			br.Detach();
		}
                // else
                // use default background color
		break;
        }
	return hbr;
}

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