rscgdlg.h

数据库 sql 2000 vc++ mfc几个简单的例子

#ifndef _RsCgDlg_H_
#define _RsCgDlg_H_

#if _MSC_VER >= 1000
#pragma once
#endif // _MSC_VER >= 1000

#include "resource.h"
// CG : In order to use this code against a different version of ADO, the appropriate
// ADO library needs to be used in the #import statement
#import "C:\Program Files\Common Files\system\ado\msado20.tlb" rename_namespace("ADOCG") rename("EOF", "EndOfFile")
using namespace ADOCG;
#include "icrsint.h"

// RsCgDlg.h : header file
//

/////////////////////////////////////////////////////////////////////////////
// CCustomRs class

class CCustomRs : 
	public CADORecordBinding
{
BEGIN_ADO_BINDING(CCustomRs)
	ADO_VARIABLE_LENGTH_ENTRY2(1, adVarWChar, m_wszid, sizeof(m_wszid), lidStatus, FALSE)
	ADO_VARIABLE_LENGTH_ENTRY2(2, adVarWChar, m_wszname, sizeof(m_wszname), lnameStatus, FALSE)
	ADO_FIXED_LENGTH_ENTRY(3, adSmallInt, m_sage, lageStatus, FALSE)
	ADO_VARIABLE_LENGTH_ENTRY2(4, adVarWChar, m_wszsex, sizeof(m_wszsex), lsexStatus, FALSE)
	ADO_VARIABLE_LENGTH_ENTRY2(5, adVarWChar, m_wszemail, sizeof(m_wszemail), lemailStatus, FALSE)
END_ADO_BINDING()

protected:
	WCHAR m_wszid[9];
	ULONG lidStatus;
	WCHAR m_wszname[256];
	ULONG lnameStatus;
	SHORT m_sage;
	ULONG lageStatus;
	WCHAR m_wszsex[256];
	ULONG lsexStatus;
	WCHAR m_wszemail[256];
	ULONG lemailStatus;
};

//
// TODO : These definitions should be moved to the resource header.
//
#define ID_BTN_MOVEPREVIOUS			201
#define ID_BTN_MOVENEXT				202
#define ID_BTN_MOVELAST				203
#define ID_BTN_MOVEFIRST				204
#define IDC_STATIC_ID		1001
#define IDC_EDIT_ID		2001
#define IDC_STATIC_NAME		1002
#define IDC_EDIT_NAME		2002
#define IDC_STATIC_AGE		1003
#define IDC_EDIT_AGE		2003
#define IDC_STATIC_SEX		1004
#define IDC_EDIT_SEX		2004
#define IDC_STATIC_EMAIL		1005
#define IDC_EDIT_EMAIL		2005


/////////////////////////////////////////////////////////////////////////////
// CRsCgDlg dialog

class CRsCgDlg : 
	public CDialog, 
	public CCustomRs
{
// Construction
public:
	CRsCgDlg(CWnd* pParent = NULL);
	~CRsCgDlg();

	BOOL OnInitDialog();

// Dialog Data
	//{{AFX_DATA(CRsCgDlg)
	enum { IDD = CG_IDD_RECORDSET };
	CEdit	m_objkey;
	CString m_strDlgid;
	CString m_strDlgname;
	SHORT m_sDlgage;
	CString m_strDlgsex;
	CString m_strDlgemail;
	CString	m_key;
	//}}AFX_DATA
	

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CRsCgDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:

	void RefreshBoundData();
	void GenerateError(HRESULT hr, PWSTR pwszDescription);
	
	_RecordsetPtr m_pRs;
	CString m_strConnection;
	CString m_strCmdText;

	// Generated message map functions
	//{{AFX_MSG(CRsCgDlg)
	afx_msg void OnBtnMoveFirst();
	afx_msg void OnBtnMoveLast();
	afx_msg void OnBtnMoveNext();
	afx_msg void OnBtnMovePrevious();
	afx_msg void OnSaverecord();
	afx_msg void OnDeleterecord();
	afx_msg void OnAddrecord();
	afx_msg void OnDestroy();
	afx_msg void OnQuery();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Developer Studio will insert additional declarations immediately before the previous line.

#endif // !_RsCgDlg_H_