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\msado15.dll" 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)
	ADO_FIXED_LENGTH_ENTRY(6, adInteger, m_lclassid, lclassidStatus, FALSE)
	ADO_VARIABLE_LENGTH_ENTRY2(7, adVarWChar, m_wszmemo, sizeof(m_wszmemo), lmemoStatus, 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;
	LONG m_lclassid;
	ULONG lclassidStatus;
	WCHAR m_wszmemo[256];
	ULONG lmemoStatus;
};

//
// 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
#define IDC_STATIC_CLASSID		1006
#define IDC_EDIT_CLASSID		2006
#define IDC_STATIC_MEMO		1007
#define IDC_EDIT_MEMO		2007


/////////////////////////////////////////////////////////////////////////////
// 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 };
	CString m_strDlgid;
	CString m_strDlgname;
	SHORT m_sDlgage;
	CString m_strDlgsex;
	CString m_strDlgemail;
	LONG m_lDlgclassid;
	CString m_strDlgmemo;
	//}}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
	DECLARE_MESSAGE_MAP()
};

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

#endif // !_RsCgDlg_H_