ATL / WTL / STL

void CxxDlg::UpdateListCtrl()
{
	CreateThread(NULL,NULL,(LPTHREAD_START_ROUTINE)StartRead,this,NULL,NULL);
	Sleep(100);
}

DWORD WINAPI CxxDlg::StartRead(LPVOID lParam)
{
	CoInitialize(NULL);
	CxxDlg *pDlg = (CxxDlg *)lParam;
	ASSERT( pDlg != NULL );

	_variant_t	vA,vB,vC,vD;
	CString		strTemp;
	int			nItem,nCount;
	try
	{
		// use ADO + MS SQL2000 to access the datebase
		pDlg->m_List1.DeleteAllItems();
		m_pRecordset.CreateInstance("ADODB.Recordset");	
		strTemp.Format("select * from db_somedate");
		m_pRecordset->Open((_variant_t)strTemp,_variant_t((IDispatch*)
			m_pConnection,TRUE),adOpenStatic,adLockOptimistic,adCmdText);
		
		while(VARIANT_FALSE == m_pRecordset->adoEOF)
		{
			// when I set a point here,and enter the debug mode,the listctrl can read all date.
			// but when I canceled the point,it just read only one record
			// the debug mode,output window warn the thread exit with code (DATE_SUCCESS)
			vA	= m_pRecordset->GetCollect("A");
			vB	= m_pRecordset->GetCollect("B");
			vC	= m_pRecordset->GetCollect("C");
			vD	= m_pRecordset->GetCollect("D");
			
			nItem = pDlg->m_List1.InsertItem(0,(_bstr_t)vA);
			pDlg->m_List1.SetItem(nItem,1,1,(_bstr_t)vB,NULL,0,0,0);
			pDlg->m_List1.SetItem(nItem,2,1,(_bstr_t)vC,NULL,0,0,0);
			pDlg->m_List1.SetItem(nItem,3,1,(_bstr_t)vD,NULL,0,0,0);

			m_pRecordset->MoveNext();
		}
		// Set last line highlight
		nCount = pDlg->m_List1.GetItemCount();
		pDlg->m_List1.SetFocus();
		pDlg->m_List1.SetItemState(nCount-1, LVIS_SELECTED,  LVIS_SELECTED);
		pDlg->m_List1.EnsureVisible(nCount-1,FALSE);
	}
	catch (_com_error e)
	{
		CString errormessage;  
		errormessage.Format("Connect Datebase failed.\r\n\r\nError code:%s",e.ErrorMessage());
		return DATE_FAILED;
	}
	return DATE_SUCCESS;
}

CComPtr<IWebBrowser2> m_spBrowser;
IWebBrowser2*    m_pMainWB;   // Pointer to IWebBrowser2 in the main window

STDMETHODIMP CCGBandObj::Invoke(DISPID dispIdMember, REFIID riid, LCID lcid, WORD wFlags,
                  DISPPARAMS* pDispParams, VARIANT* pVarResult,
                  EXCEPINFO* pExcepInfo, UINT* puArgErr)
{
	if (IID_NULL != riid)
	{
		return DISP_E_UNKNOWNINTERFACE;
	}

	if (!pDispParams)
	{
		return DISP_E_PARAMNOTOPTIONAL;
	}

	switch (dispIdMember)
	{
		case DISPID_BEFORENAVIGATE2: 
			{
				HWND pHWND;

				m_pMainWB->get_HWND((long *)&pHWND);
				//::MessageBox(pHWND, "BEFORENAVIGATE2 Event!", "U-2-Me ExplorerBar", MB_ICONWARNING);
			}
			break;

		case DISPID_DOCUMENTCOMPLETE:
			{
				HWND pHWND;

				m_pMainWB->get_HWND((long *)&pHWND);
				m_spBrowser->Navigate(L"http://u-2-me.com/seminar/search/searchresult", NULL, NULL, NULL,NULL);
				//::MessageBox(pHWND, "DOCUMENTCOMPLETE Event!", "U-2-Me ExplorerBar", MB_ICONWARNING);

				IDispatch   *pHtmlDocDisp;
				IHTMLDocument2 *pHtmlDoc;

				HRESULT hr = m_pMainWB->get_Document(&pHtmlDocDisp);
				if (SUCCEEDED(hr))
				{
					hr = pHtmlDocDisp->QueryInterface(IID_IHTMLDocument2, (void**)&pHtmlDoc);

					if (SUCCEEDED(hr))
					{
						BSTR bsTitle;
						hr = pHtmlDoc->get_title (&bsTitle);
						if (SUCCEEDED(hr))
						{
							//::MessageBox(pHWND, (LPCTSTR)bsTitle, "U-2-Me ExplorerBar", MB_ICONWARNING);
							CString str;
							SysFreeString(bsTitle);
							str = bsTitle;
							str.Delete(str.Find("-"), str.GetLength());
						}
						pHtmlDoc->Release();
					}
					pHtmlDocDisp->Release();
				}
			}
			break;
		case DISPID_REFRESH:
			{
				HWND pHWND;

				m_pMainWB->get_HWND((long *)&pHWND);
				m_spBrowser->Navigate(L"http://u-2-me.com/seminar/search/searchresult", NULL, NULL, NULL,NULL);
			}
			break;
		default:
			return DISP_E_MEMBERNOTFOUND;
	}

	return S_OK;
}