adodatebaseview.h

实现了在VC++环境下操作excel数据库

// AdoDateBaseView.h : interface of the CAdoDateBaseView class
//
/////////////////////////////////////////////////////////////////////////////
//{{AFX_INCLUDES()
#include "datagrid.h"
//}}AFX_INCLUDES

#if !defined(AFX_ADODATEBASEVIEW_H__EF0387C3_BE33_4BF1_B80B_E15358E33D1B__INCLUDED_)
#define AFX_ADODATEBASEVIEW_H__EF0387C3_BE33_4BF1_B80B_E15358E33D1B__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "datagrid.h"
#include "column.h"
#include "columns.h"
class CAdoDateBaseView : public CFormView
{
protected: // create from serialization only
	CAdoDateBaseView();
	DECLARE_DYNCREATE(CAdoDateBaseView)

public:
	//{{AFX_DATA(CAdoDateBaseView)
	enum { IDD = IDD_ADODATEBASE_FORM };
	CListBox	m_ListBox;
	CDataGrid	m_DataGrid;
	CString	m_strConnection;
	CString	m_strSQL;
	//}}AFX_DATA

// Attributes
public:
	CAdoDateBaseDoc* GetDocument();

// Operations
public:

// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAdoDateBaseView)
	public:
	virtual BOOL PreCreateWindow(CREATESTRUCT& cs);
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	virtual void OnInitialUpdate(); // called first time after construct
	virtual BOOL OnPreparePrinting(CPrintInfo* pInfo);
	virtual void OnBeginPrinting(CDC* pDC, CPrintInfo* pInfo);
	virtual void OnEndPrinting(CDC* pDC, CPrintInfo* pInfo);
	virtual void OnPrint(CDC* pDC, CPrintInfo* pInfo);
	//}}AFX_VIRTUAL

// Implementation
public:
	void getTables();
	CString m_strError;
	void GenerateError(HRESULT hr,PWSTR pwszDescription);
	BOOL isDesc;
	CString m_strTableName;
	_RecordsetPtr m_Recordset;
	_ConnectionPtr m_Connection;
	virtual ~CAdoDateBaseView();
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif

protected:

// Generated message map functions
protected:
	//{{AFX_MSG(CAdoDateBaseView)
	afx_msg void OnConnect();
	afx_msg void OnSource();
	afx_msg void OnExecute();
	afx_msg void OnDisconnect();
	afx_msg void OnQuit();
	afx_msg void OnSelchangeList();
	afx_msg void OnHeadClickDatagrid(short ColIndex);
	DECLARE_EVENTSINK_MAP()
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

#ifndef _DEBUG  // debug version in AdoDateBaseView.cpp
inline CAdoDateBaseDoc* CAdoDateBaseView::GetDocument()
   { return (CAdoDateBaseDoc*)m_pDocument; }
#endif

/////////////////////////////////////////////////////////////////////////////

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

#endif // !defined(AFX_ADODATEBASEVIEW_H__EF0387C3_BE33_4BF1_B80B_E15358E33D1B__INCLUDED_)