accesstestdlg.h

通过ODBC访问Access数据库的操作

// AccessTestDlg.h : header file
//

#if !defined(AFX_ACCESSTESTDLG_H__DF0B6B62_7693_4C49_970C_6CF2BFE77A79__INCLUDED_)
#define AFX_ACCESSTESTDLG_H__DF0B6B62_7693_4C49_970C_6CF2BFE77A79__INCLUDED_

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

//#include "afxdb.h"
#include <odbcinst.h>
#include "MyRecordset.h"
/////////////////////////////////////////////////////////////////////////////
// CAccessTestDlg dialog
typedef struct 
{	
	int           UserID;
	char          UserName[16];
    char          UserType[10];
    char          Password[16];	
}VIDEO_USER;

class CAccessTestDlg : public CDialog
{
// Construction
public:
	CAccessTestDlg(CWnd* pParent = NULL);	// standard constructor

	CMyRecordset* m_pSet;
	CDatabase* m_database;

	VIDEO_USER vmsuser; 
	int m_CurItemCount;
	CImageList m_ImageList;
	//int CurPos;

	void InitDatabase();
	void GetAllRecord();
	void GetUserRecord();
	void SetValue(bool userid);
	int FindRecorde(CString name);
	void ModifyRecord();

// Dialog Data
	//{{AFX_DATA(CAccessTestDlg)
	enum { IDD = IDD_ACCESSTEST_DIALOG };
	CComboBox	m_usertypectrl;
	CListCtrl	m_List1;
	CString	m_UserName;
	CString	m_PassWord;
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CAccessTestDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnBtnadd();
	afx_msg void OnBtnmodifi();
	afx_msg void OnBtndelete();
	afx_msg void OnItemchangedList1(NMHDR* pNMHDR, LRESULT* pResult);
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_ACCESSTESTDLG_H__DF0B6B62_7693_4C49_970C_6CF2BFE77A79__INCLUDED_)