adodlg.h

ADO数据库编程

// AdoDlg.h : header file
//

#if !defined(AFX_ADODLG_H__AACB1767_83DB_11D4_9BD6_00104BC71186__INCLUDED_)
#define AFX_ADODLG_H__AACB1767_83DB_11D4_9BD6_00104BC71186__INCLUDED_

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

//自定义控件的头文件
#include "CustomGrid.h"

/////////////////////////////////////////////////////////////////////////////
// CAdoDlg dialog

class CAdoDlg : public CDialog
{
// Construction
public:
	CAdoDlg(CWnd* pParent = NULL);	// standard constructor
	~CAdoDlg();
	void ChangeVariantType(UINT& type);//转换与VC++对应的数据库数据类型
	void GetTablesName();
	void CloseTable();
	void CloseDatabase();
	void SetButtonCtrl();

public:
	_ConnectionPtr     m_piConnection;
	_RecordsetPtr      m_piRecordset;
	_CommandPtr        m_piCommand;

	CCustomGrid          m_Grid;
	bool               m_bEditable;
	long               m_nModified;
	long               m_nSelectedRow;
	UINT*              m_pFieldsType;
	long               m_nFieldCount;
	bool               m_bDataOpened;
	bool               m_bTableOpened;
	//CString            m_strDatabaseName;
	//CString            m_strTableName;

// Dialog Data
	//{{AFX_DATA(CAdoDlg)
	enum { IDD = IDD_ADO_DIALOG };
		// NOTE: the ClassWizard will add data members here
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CAdoDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnDatabase();
	afx_msg void OnSelchangeTablelist();
	afx_msg void OnAdd();
	afx_msg void OnDelete();
	afx_msg void OnModify();
	//}}AFX_MSG
	afx_msg void OnGridClick(NMHDR* pNMHDR, LRESULT* pResult);//单击栅格
	afx_msg void OnGridDBClick(NMHDR* pNMHDR, LRESULT* pResult);//双击栅格
	DECLARE_MESSAGE_MAP()
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_ADODLG_H__AACB1767_83DB_11D4_9BD6_00104BC71186__INCLUDED_)