C / C++ / MFC

<br />
  //<br />
  // Reconstruct annotations from database<br />
  ///////////////////////////////////////////////////////////////////////////<br />
  _RecordsetPtr pAnnoRs = NULL;<br />
  _StreamPtr pStream = NULL;<br />
  CString strSQL;<br />
  _bstr_t strMissing(L"");<br />
  BOOL bEmpty = TRUE;<br />
<br />
  try<br />
  {<br />
		TESTHR(pAnnoRs.CreateInstance(__uuidof(Recordset)));<br />
		TESTHR(pStream.CreateInstance(__uuidof(Stream)));<br />
  		strSQL.Format(_T("SELECT `tblAnnotations`.* FROM `tblAnnotations` WHERE `tblAnnotations`.`imageID` = %d;"), nImageID);<br />
		TESTHR(pAnnoRs->Open( (_bstr_t) strSQL, _variant_t((IDispatch*) thisMainFrm.pConnection), adOpenKeyset, adLockOptimistic, adCmdTableDirect));<br />
		<br />
		if  (!pAnnoRs->GetadoEOF())<br />
		{<br />
		  TESTHR(pStream->Open(vtMissing, adModeUnknown, adOpenStreamUnspecified, strMissing, strMissing));<br />
		  TESTHR(pStream->put_Type(adTypeBinary));<br />
		  TESTHR(pStream->Write(pAnnoRs->Fields->GetItem(L"BLOB")->Value)); // This gets the blob data<br />
		  TESTHR(pStream->SaveToFile( (_bstr_t) strDir, adSaveCreateOverWrite)); //This will save the data to a file on the disk, in your case save as c:\myfile.bmp<br />
		  TESTHR(pAnnoRs->Close());<br />
		  TESTHR(pStream->Close());<br />
		  bEmpty = FALSE;<br />
		}<br />
  }<br />
  catch (_com_error &e)<br />
  {<br />
	TRACE(_T("COM error in CThumbBar::OnThumbCopyAndPaste()"));<br />
	TRACE(_T("Error:%081x.\n"), e.Error());<br />
	TRACE(_T("ErrorMessage:%s.\n"), e.ErrorMessage());<br />
	TRACE(_T("Source:%s.\n"), (LPCTSTR) _bstr_t(e.Source()));<br />
	TRACE(_T("Description:%s.\n"), (LPCSTR) _bstr_t(e.Description()));<br />
	return FALSE;<br />
  }<br />
  catch (int)<br />
  {<br />
	;<br />
  }<br />

• HACCEL - Handle to an accelerator table.
  
• HANDLE - Handle to an object.
  
• HBITMAP - Handle to a bitmap.
  
• HBRUSH - Handle to a brush.
  
• HCOLORSPACE - Handle to a logical color space.
  
• HCONV - Handle to a dynamic data exchange (DDE) conversation.
  
• HCONVLIST - Handle to a DDE conversation list.
  
• HCURSOR - Handle to a cursor.
  
• HDC - Handle to a device context (DC).
  
• HDDEDATA - Handle to DDE data.
  
• HDESK - Handle to a desktop.
  
• HDROP - Handle to an internal drop structure.
  
• HDWP - Handle to a deferred window position structure.
  
• HENHMETAFILE - Handle to an enhanced metafile.
  
• HFILE - Handle to a file opened byOpenFile, notCreateFile.
  
• HFONT - Handle to a font.
  
• HGDIOBJ - Handle to a GDI object.
  
• HGLOBAL - Handle to a global memory block.
  
• HHOOK - Handle to a hook.
  
• HICON - Handle to an icon.
  
• HIMAGELIST - Handle to an image list.
  
• HIMC - Handle to input context.
  
• HINSTANCE - Handle to an instance.
  
• HKEY - Handle to a registry key.
  
• HKL - Handle to a keyboard layout.
  
• HLOCAL - Handle to a local memory block.
  
• HMENU - Handle to a menu.
  
• HMETAFILE - Handle to a metafile.
  
• HMODULE - Handle to a module.
  
• HMONITOR - Handle to a display monitor.
  
• HOOKPROC - Pointer to an application-defined hook function specified toSetWindowsHookEx.
  
• HPALETTE - Handle to a palette.
  
• HPEN - Handle to a pen.
  
• HRGN - Handle to a region.
  
• HRSRC - Handle to a resource.
  
• HSZ - Handle to a DDE string.
  
• HTREEITEM - Handle to an item in a tree-view control.
  
• HWINSTA - Handle to a window station.
  
• HWND - Handle to a window.