C / C++ / MFC

<br />
<br />
CFrameWnd* pFrame=(CFrameWnd*)AfxGetMainWnd();<br />
CTestView *p = (CTestView *)pFrame->GetActiveView();<br />
p->LoadImages(str);<br />
<br />
<br />

	int  len;                                   // Length of returned email address.
	int  result;
	char c2[255];	                            // Storage for returned email address
	char c3[]="\0"; // Email address ignore list (pipe delimited).
	char c4[]="";            // License key (See comments above.)

<br>
	//// starting message
	AfxMessageBox("Starting The Bouncer!"); 
<br>

	/// Open the DSN Connection
	HENV hEnv = NULL; // Env Handle from SQLAllocEnv()
	HDBC hDBC = NULL; // Connection handle
	HSTMT hStmt = NULL;// Statement handle
	UCHAR szDSN[SQL_MAX_DSN_LENGTH] = "cplusmysql";// Data Source Name buffer
	UCHAR szUID[10] = "xxxx";// User ID buffer 
	UCHAR szPasswd[10] = "xxxx";// Password buffer
	UCHAR szModel[128];// Model buffer
	SDWORD cbModel;// Model buffer bytes recieved
	RETCODE retcode; // Return Code
<br>	// Allocate memory for ODBC Environment handle
	SQLAllocEnv (&hEnv);
	// Allocate memory for the connection handle
	SQLAllocConnect (hEnv, &hDBC);
<br>	// Connect to the data source using userid and password.
	retcode = SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);

<br><br>	// load api
	BOOL freeResult, runTimeLinkSuccess = FALSE; 
	HINSTANCE dllHandle = NULL;     		
	BounceCheckType BounceCheckPtr = NULL;
	dllHandle = LoadLibrary("bBounce.dll");

<br>	//Get pointer to function using GetProcAddress:
	BounceCheckPtr = (BounceCheckType)GetProcAddress(dllHandle,"BBBOUNCECHECK");

	if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
	{
		// Open directory for read
		CFileInfoArray fia;
		fia.AddDir(
		   m_spoolpath,                                // Directory
		   "*.*",                                      // Filemask (all files)
		   TRUE,                                       // Recurse subdirs
		   CFileInfoArray::AP_SORTBYNAME | CFileInfoArray::AP_SORTASCENDING, // Sort by name and ascending
		   FALSE                                       // Do not add array entries for directories (only for files)
		);
	
		/// here will start the directory iteration
		for (int ji=0;ji<fia.GetSize();ji++) {

		    ifstream is;
		    is.open (fia[ji].GetFilePath(), ios::binary );
		    // get length of file:
		    is.seekg (0, ios::end);
		    int length = is.tellg();
		    is.seekg (0, ios::beg);
		    // allocate memory:
		    char * c1 = new char [length+1];
		    // read data as a block:
		    is.read (c1,length);
		    is.close();
		    c1[length+1] = '\0';

			// call api function
			if(NULL != dllHandle) 
			{
				// If the function address is valid, call the bbounce api's function. 
				if (runTimeLinkSuccess = (NULL != BounceCheckPtr))
				{
					 result = BounceCheckPtr(*c1, *c2, len, *c3, *c4);
				}
			}

			///// prepare database entry
			UCHAR szSqlStr[128];
			if (result == 1) { 

				sprintf((char*)szSqlStr,"INSERT into bouncetest Values ('HB', '%s')",c2);

				SQLAllocStmt (hDBC, &hStmt); 
				// Prepare the SQL statement by assigning it to the statement handle
				SQLPrepare (hStmt, szSqlStr, sizeof (szSqlStr)); 
				// Execute the SQL statement handle
				SQLExecute (hStmt); 
				// Project only column 1 which is the models
				SQLBindCol (hStmt, 1, SQL_C_CHAR, szModel, sizeof(szModel), &cbModel);
				// Get row of data from the result set defined above in the statement
				SQLFetch (hStmt);
				// Free the allocated statement handle
				SQLFreeStmt (hStmt, SQL_DROP);
			}

			// delete memory i create on heap
			delete[] c1;

		}
		// end directory iteration

	    //Free the library:
	    freeResult = FreeLibrary(dllHandle);	

	}

	//// End the DSN Connection	
	// Disconnect from datasource
	SQLDisconnect (hDBC);
	// Free the allocated connection handle
	SQLFreeConnect (hDBC); 
	// Free the allocated ODBC environment handle
	SQLFreeEnv (hEnv);

	AfxMessageBox("Finished Sorting Bounces");

...
char * c1 = new char [length+1];
// read data as a block:
is.read (c1,length);
is.close();
c1[length+1] = '\0';
...

c1[length] = '\0';

sprintf((char*)szSqlStr,"INSERT into bouncetest Values ('HB', '%s')",c2);