adotestdlg.h

VC代码,ADO的SQL server数据库连接,查询基本功能示范

// ADOTestDlg.h : header file
//

#if !defined(AFX_ADOTESTDLG_H__E91CF07B_DF2D_40FA_BF5A_28BBF7A99630__INCLUDED_)
#define AFX_ADOTESTDLG_H__E91CF07B_DF2D_40FA_BF5A_28BBF7A99630__INCLUDED_

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

#include "Resource.h"

/////////////////////////////////////////////////////////////////////////////
// CADOTestDlg dialog
#define MAX_SERVER_NAME	128
#define MAX_USER_NAME 64
#define MAX_PASSWORD 64
#define MAX_DATABASE_NAME 64

extern char strServer[];
extern char strUID[];
extern char strPWD[];
extern char strDBname[];


class CADOTestDlg : public CDialog
{
// Construction
public:
	CADOTestDlg(CWnd* pParent = NULL);	// standard constructor
	CString Server;
	CString UID;
	CString PWD;
	CString DBname;
	BOOL bDBConnected;

// Dialog Data
	//{{AFX_DATA(CADOTestDlg)
	enum { IDD = IDD_ADOTEST_DIALOG };
	CButton	m_QueryCntrl;
	CEdit	m_QueryResultCntrl;
	CEdit	m_QuerySentenceCntrl;
	CButton	m_DisConnectCntrl;
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CADOTestDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnButtonConnect();
	afx_msg void OnButtonDisconnect();
	afx_msg void OnDestroy();
	afx_msg void OnButtonQuery();
	afx_msg void OnChangeEditQuerySentence();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_ADOTESTDLG_H__E91CF07B_DF2D_40FA_BF5A_28BBF7A99630__INCLUDED_)