?? rscgdlg10.cpp
字號:
// RsCgDlg10.cpp : implementation file
//
#include "stdafx.h"
#include "RsCgDlg11.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CRsCgDlg7 dialog
CRsCgDlg7::CRsCgDlg7(CWnd* pParent /*=NULL*/)
: CDialog(CRsCgDlg7::IDD, pParent)
{
m_strConnection = _T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=學生選課系統;Data Source=(local)");
m_strCmdText = _T("VIEW_CHOISE");
m_pRs = NULL;
//{{AFX_DATA_INIT(CRsCgDlg7)
m_strDlgCol1 = _T("");
m_strDlgCol2 = _T("");
m_dDlgCol3 = 0;
m_strDlgCol4 = _T("");
m_strDlgCol5 = _T("");
m_strDlgCol6 = _T("");
//}}AFX_DATA_INIT
}
CRsCgDlg7::~CRsCgDlg7()
{
m_pRs = NULL;
}
BOOL CRsCgDlg7::OnInitDialog()
{
HRESULT hr = NOERROR;
IADORecordBinding *piAdoRecordBinding = NULL;
CDialog::OnInitDialog();
try
{
m_pRs.CreateInstance(__uuidof(Recordset));
m_pRs->CursorLocation = adUseClient;
m_pRs->Open((LPCTSTR)m_strCmdText, (LPCTSTR)m_strConnection, adOpenKeyset,
adLockReadOnly, adCmdTableDirect);
if (FAILED(hr = m_pRs->QueryInterface(__uuidof(IADORecordBinding), (LPVOID *)&piAdoRecordBinding)))
_com_issue_error(hr);
if (FAILED(hr = piAdoRecordBinding->BindToRecordset(this)))
_com_issue_error(hr);
RefreshBoundData();
}
catch (_com_error &e)
{
GenerateError(e.Error(), e.Description());
}
if (piAdoRecordBinding)
piAdoRecordBinding->Release();
return TRUE;
}
void CRsCgDlg7::RefreshBoundData()
{
if (adFldOK == lCol1Status)
m_strDlgCol1 = m_wszCol1;
else
m_strDlgCol1 = _T("");
if (adFldOK == lCol2Status)
m_strDlgCol2 = m_wszCol2;
else
m_strDlgCol2 = _T("");
if (adFldOK == lCol3Status)
m_dDlgCol3 = m_dCol3;
else
m_dDlgCol3 = 0;
if (adFldOK == lCol4Status)
m_strDlgCol4 = m_wszCol4;
else
m_strDlgCol4 = _T("");
if (adFldOK == lCol5Status)
m_strDlgCol5 = m_wszCol5;
else
m_strDlgCol5 = _T("");
if (adFldOK == lCol6Status)
m_strDlgCol6 = m_wszCol6;
else
m_strDlgCol6 = _T("");
UpdateData(FALSE);
}
void CRsCgDlg7::GenerateError(HRESULT hr, PWSTR pwszDescription)
{
CString strError;
strError.Format("Run-time error '%d (%x)'", hr, hr);
strError += "\n\n";
strError += pwszDescription;
AfxMessageBox(strError);
}
void CRsCgDlg7::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CRsCgDlg7)
DDX_Text(pDX, IDC_EDIT_COL1, m_strDlgCol1);
DDX_Text(pDX, IDC_EDIT_COL2, m_strDlgCol2);
DDX_Text(pDX, IDC_EDIT_COL3, m_dDlgCol3);
DDX_Text(pDX, IDC_EDIT_COL4, m_strDlgCol4);
DDX_Text(pDX, IDC_EDIT_COL5, m_strDlgCol5);
DDX_Text(pDX, IDC_EDIT_COL6, m_strDlgCol6);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CRsCgDlg7, CDialog)
//{{AFX_MSG_MAP(CRsCgDlg7)
ON_BN_CLICKED(ID_BTN_MOVEFIRST, OnBtnMoveFirst)
ON_BN_CLICKED(ID_BTN_MOVELAST, OnBtnMoveLast)
ON_BN_CLICKED(ID_BTN_MOVENEXT, OnBtnMoveNext)
ON_BN_CLICKED(ID_BTN_MOVEPREVIOUS, OnBtnMovePrevious)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CRsCgDlg7 message handlers
void CRsCgDlg7::OnBtnMoveFirst()
{
try
{
m_pRs->MoveFirst();
RefreshBoundData();
}
catch (_com_error &e)
{
GenerateError(e.Error(), e.Description());
}
}
void CRsCgDlg7::OnBtnMoveLast()
{
try
{
m_pRs->MoveLast();
RefreshBoundData();
}
catch (_com_error &e)
{
GenerateError(e.Error(), e.Description());
}
}
void CRsCgDlg7::OnBtnMoveNext()
{
try
{
m_pRs->MoveNext();
RefreshBoundData();
}
catch (_com_error &e)
{
GenerateError(e.Error(), e.Description());
}
}
void CRsCgDlg7::OnBtnMovePrevious()
{
try
{
m_pRs->MovePrevious();
RefreshBoundData();
}
catch (_com_error &e)
{
GenerateError(e.Error(), e.Description());
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -