regionsempnumbersviewdlg.cpp

A HR database application.

// RegionsEmpNumbersViewDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HRDB.h"
#include "RegionsEmpNumbersViewDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

//引入全局变量userName,passWord
extern CString   userName;
extern CString   passWord;

/////////////////////////////////////////////////////////////////////////////
// CRegionsEmpNumbersViewDlg dialog


CRegionsEmpNumbersViewDlg::CRegionsEmpNumbersViewDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRegionsEmpNumbersViewDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRegionsEmpNumbersViewDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CRegionsEmpNumbersViewDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRegionsEmpNumbersViewDlg)
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRegionsEmpNumbersViewDlg, CDialog)
	//{{AFX_MSG_MAP(CRegionsEmpNumbersViewDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRegionsEmpNumbersViewDlg message handlers

BOOL CRegionsEmpNumbersViewDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	try
	{
		//初始化ADODC数据源
		m_Adodc.SetConnectionString("Provider=MSDASQL.1; Password=" + passWord +
			"; Persist Security Info=True; User ID=" + userName + "; Data Source=hr; Initial Catalog=hr");
		m_Adodc.SetRecordSource("select * from regions_emp_view");
		m_Adodc.Refresh(); //important

		//将DATAGRID绑定到ADODC控件
		LPUNKNOWN pcursor = m_Adodc.GetDSCCursor();
		m_DataGrid.SetRefDataSource(pcursor);
	}
	catch (...) //捕获任何类型的异常
	{
		AfxMessageBox("无权查询!");
	}

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}