|
// ODBCExampleDlg.cpp : implementation file
//
#include "stdafx.h"
#include "ODBCExample.h"
#include "ODBCExampleDlg.h"
#include "Operations.h"
#include "Config.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About
class CAboutDlg : public CDialog
{
public:
CAboutDlg();
// Dialog Data
//{{AFX_DATA(CAboutDlg)
enum { IDD = IDD_ABOUTBOX };
//}}AFX_DATA
// ClassWizard generated virtual function overrides
//{{AFX_VIRTUAL(CAboutDlg)
protected:
virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support
//}}AFX_VIRTUAL
// Implementation
protected:
//{{AFX_MSG(CAboutDlg)
//}}AFX_MSG
DECLARE_MESSAGE_MAP()
};
CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
//{{AFX_DATA_INIT(CAboutDlg)
//}}AFX_DATA_INIT
}
void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAboutDlg)
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
//{{AFX_MSG_MAP(CAboutDlg)
// No message handlers
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CODBCExampleDlg dialog
CODBCExampleDlg::CODBCExampleDlg(CWnd* pParent /*=NULL*/)
: CDialog(CODBCExampleDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CODBCExampleDlg)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}
void CODBCExampleDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CODBCExampleDlg)
// NOTE: the ClassWizard will add DDX and DDV calls here
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CODBCExampleDlg, CDialog)
//{{AFX_MSG_MAP(CODBCExampleDlg)
ON_WM_SYSCOMMAND()
ON_WM_PAINT()
ON_WM_QUERYDRAGICON()
ON_BN_CLICKED(IDC_CONNECT, OnConnect)
ON_BN_CLICKED(IDC_DATASOURCE, OnDatasource)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CODBCExampleDlg message handlers
BOOL CODBCExampleDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// Add "About..." menu item to system menu.
// IDM_ABOUTBOX must be in the system command range.
ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
ASSERT(IDM_ABOUTBOX < 0xF000);
CMenu* pSysMenu = GetSystemMenu(FALSE);
if (pSysMenu != NULL)
{
CString strAboutMenu;
strAboutMenu.LoadString(IDS_ABOUTBOX);
if (!strAboutMenu.IsEmpty())
{
pSysMenu->AppendMenu(MF_SEPARATOR);
pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
}
}
// Set the icon for this dialog. The framework does this automatically
// when the application's main window is not a dialog
SetIcon(m_hIcon, TRUE); // Set big icon
SetIcon(m_hIcon, FALSE); // Set small icon
//Configure the datasource which we are using by calling
//CODBAccess::ConfigDataSource:
CFileFind fullName;
if(fullName.FindFile("employ.mdb"))
{
fullName.FindNextFile();
m_db.ConfigDataSource(DATASOURCE_ADD,
"ODBCExample", fullName.GetFilePath(), false,
"ODBCExample Database");
}
return TRUE; // return TRUE unless you set the focus to a control
}
void CODBCExampleDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
if ((nID & 0xFFF0) == IDM_ABOUTBOX)
{
CAboutDlg dlgAbout;
dlgAbout.DoModal();
}
else
{
CDialog::OnSysCommand(nID, lParam);
}
}
// If you add a minimize button to your dialog, you will need the code below
// to draw the icon. For MFC applications using the document/view model,
// this is automatically done for you by the framework.
void CODBCExampleDlg::OnPaint()
{
if (IsIconic())
{
CPaintDC dc(this); // device context for painting
SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);
// Center icon in client rectangle
int cxIcon = GetSystemMetrics(SM_CXICON);
int cyIcon = GetSystemMetrics(SM_CYICON);
CRect rect;
GetClientRect(&rect);
int x = (rect.Width() - cxIcon + 1) / 2;
int y = (rect.Height() - cyIcon + 1) / 2;
// Draw the icon
dc.DrawIcon(x, y, m_hIcon);
}
else
{
CDialog::OnPaint();
}
}
// The system calls this to obtain the cursor to display while the user drags
// the minimized window.
HCURSOR CODBCExampleDlg::OnQueryDragIcon()
{
return (HCURSOR) m_hIcon;
}
//Static function to display a message box based on an error code
void CODBCExampleDlg::DisplayErrorBox(CODBCAccess *db)
{
CString type;
CString explain;
int code = db->GetLastErrCode();
//Get the equivalent type from the code:
if(code == 0)
{
type = "RETURN_SUCCESS";
explain = "The operation was successful!";
}
else if(code == 1)
{
type = "RETURN_ARGUMENT";
explain = "You tried to call a function with a bad argument.";
}
else if(code == 2)
{
type = "RETURN_ERRMSG";
explain = "Generic error message, use GetLastErrMsg to find the specific problem.";
}
else if(code == 3)
{
type = "RETURN_DB";
explain = "The database was not opened beforehand.";
}
else if(code == 4)
{
type = "RETURN_CRITICAL";
explain = "There was a critical error, the database was closed "
"for safety. Use GetLastErrMsg to examine the exact problem.";
}
//Show the message box:
::MessageBox(AfxGetApp()->m_pMainWnd->GetSafeHwnd(), "CODBCAccess returned the following information from the "
"last function call:\n\nType: " + type + "\nExplaination: " + explain +
"\n\nError Message: " + db->GetLastErrMsg(),
"CODBCAccess Returned Information", MB_ICONINFORMATION);
}
//Configures a data source
void CODBCExampleDlg::OnDatasource()
{
//Open the config dialog:
CConfig con;
con.db = &m_db;
con.DoModal();
}
//Connects to a data source
void CODBCExampleDlg::OnConnect()
{
//Connect using selected data source:
m_db.Connect();
//And open the operations dialog:
COperations op;
op.db = &m_db;
op.DoModal();
//When doModal returns, we have to close the db:
m_db.Disconnect();
}
void CODBCExampleDlg::OnOK()
{
//Delete the datasource we made:
//(if the function fails it doesn't matter):
m_db.ConfigDataSource(DATASOURCE_DEL, "ODBCExample",
"ODBCExample", false);
CDialog::OnOK();
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I work with C++, C#, Perl, PHP, HTML (with a lot of CSS), and a little bit of ASP.NET. I have been programming for 7 years.
I also enjoy translating Latin, and especially reading authors whose primary language was Latin, including Virgil (or Vergil for the Latinate spelling), Julius Caesar, Catullus, Cicero, and some others (like Martial). I enjoy classical music, most especially Mozart and Bach.