C / C++ / MFC

HINSTANCE hInst = 0;
HHOOK hook = 0;
HWND hWnd = 0;
DWORD ProcessID = 0;
 
static LRESULT CALLBACK CBTHook(int, WPARAM, LPARAM);
 
__declspec(dllexport) BOOL SetDUDWCHook(DWORD _ProcessID)
{
   if (!hook)
   {
      hook = SetWindowsHookEx(WH_CBT, (HOOKPROC)CBTHook, hInst, 0);
      if (hook)
      {
         ProcessID = _ProcessID;
         return TRUE;
      }
   }
   return FALSE;
}
 
__declspec(dllexport) void ClearDUDWCHook()
{
   if (hook && UnhookWindowsHookEx(hook))
   {
      hook = 0;
      hWnd = 0;
      ProcessID = 0;
   }
}
 
__declspec(dllexport) void KillDUD()
{
   if (hWnd && IsWindow(hWnd))
   {
      PostMessage(hWnd, WM_CLOSE, 0, 0);
      PostMessage(hWnd, WM_CLOSE, 0, 0);
      ClearDUDWCHook();
   }
}
 
static LRESULT CALLBACK CBTHook(int nCode, WPARAM wParam, LPARAM lParam)
{
   if (nCode == HCBT_CREATEWND && !hWnd)
   {
      HWND Window = (HWND)wParam;
      CBT_CREATEWND *pCW = (CBT_CREATEWND *)lParam;
      DWORD Process = 0;
      GetWindowThreadProcessId(Window, &Process);
      if (Process == ProcessID)
         hWnd = Window;
   }
   return CallNextHookEx(hook, nCode, wParam, lParam;
}

CDatabase database;<br />
CString sSql;<br />
<br />
sDriver = GetExcelDriver();<br />
    if (sDriver.IsEmpty())<br />
    {<br />
        // Blast! We didn´t find that driver!<br />
        AfxMessageBox("No Excel ODBC driver found");<br />
        return;<br />
    }<br />
    <br />
    // Create a pseudo DSN including the name of the Driver and the Excel file<br />
    // so we don´t have to have an explicit DSN installed in our ODBC admin<br />
    sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s", sDriver, m_sFileName);TRY<br />
    {<br />
        // Open the database using the former created pseudo DSN<br />
        database.Open(NULL, false, false, sDsn);<br />
        <br />
        // Allocate the recordset<br />
        CRecordset recset(&database);<br />
<br />
        // Build the SQL string<br />
        sSql = "SELECT Date, Heure, " + m_sColumn + " FROM [Feuil1$A1:IV65536] WHERE Operateur='SFR'";<br />
    <br />
        // Execute that query (implicitly by opening the recordset)<br />
        recset.Open(CRecordset::forwardOnly, sSql, CRecordset::readOnly);// Browse the result<br />
        while (!recset.IsEOF())<br />
        {<br />
            // Read the result line<br />
            recset.GetFieldValue(m_sColumn, sValue);<br />
            recset.GetFieldValue("Date", sDate);<br />
            recset.GetFieldValue("Heure", sHeure);<br />
<br />
            if(-1 != sDate.Find(strDate))<br />
            {<br />
               int iSpacePos = sHeure.Find(" ");<br />
               if(-1 != iSpacePos)<br />
               {<br />
                  sTime = sHeure.Right(sHeure.GetLength() - iSpacePos);<br />
                  sTime.TrimLeft();<br />
                  sTime.TrimRight();<br />
                  <br />
                  sHour    = sTime.Mid(0, 2);<br />
                  sMinutes = sTime.Mid(3, 2);<br />
                  sSeconds = sTime.Mid(6, 2);<br />
                  <br />
                  CTime tTime(2000, 1, 1, atoi(sHour), atoi(sMinutes), atoi(sSeconds));<br />
                  m_aTimes.Add(tTime);<br />
               }<br />
               <br />
               m_doubleArray.Add(atof((LPCTSTR)sValue));<br />
            }<br />
<br />
            // Skip to the next resultline<br />
            recset.MoveNext();<br />
        }<br />
// Close the database<br />
        database.Close();<br />
                             <br />
    }<br />
    CATCH(CDBException, e)<br />
    {<br />
        // A database exception occured. Pop out the details...<br />
        AfxMessageBox("Database error: " + e->m_strError);<br />
    }<br />
    END_CATCH;

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

while ((status = GetMessage (& msg, 0, 0, 0)) > 0 && IsWindow(hDg))