chnidlg.h

读取数据库数据显示到把列表控件

// chniDlg.h : header file
//

#if !defined(AFX_CHNIDLG_H__C04E9F7A_4C39_4658_878E_FA6EF3A71B85__INCLUDED_)
#define AFX_CHNIDLG_H__C04E9F7A_4C39_4658_878E_FA6EF3A71B85__INCLUDED_

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

/////////////////////////////////////////////////////////////////////////////
// CChniDlg dialog

class CChniDlg : public CDialog
{
// Construction
public:
  
    bool		DBConnect(CString strDataSource);
 //   void   Selectmark(CString mark);
    void          Dateselect();

	_ConnectionPtr	pConnection;
	CString			strFileName,strFileTitle,strfileext;
	int    record,nSel ;;


	bool			bAccessFlag;//数据库连接成功与否标志
CString		GetExcelDriver();
BOOL GetDefaultXlsFileName(CString& sExcelFile);
BOOL		MakeSurePathExists( CString &Path,	bool FilenameIncluded=true);
void		ExportListToExcel();   

	CChniDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CChniDlg)
	enum { IDD = IDD_CHNI_DIALOG };
	CStatic	m_pageshow;
	CStatic	m_pagenum;
	CStatic	m_record;
	CComboBoxEx	m_combo_value;
	CStatic	m_static_value;
	CEdit	m_edit_path;
	CListCtrl	m_list_value;
	CString	m_edit_pathvalue;
	CString	m_edit_select;
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CChniDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnButtonPath();
	afx_msg void OnButtonConnect();
	afx_msg void OnBUTTONselect();
	afx_msg void OnButtonLoad();
	afx_msg void OnSelchangeComboboxexSelect();
	afx_msg void OnButtonNextpage();
	afx_msg void OnButtonPrevpage();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_CHNIDLG_H__C04E9F7A_4C39_4658_878E_FA6EF3A71B85__INCLUDED_)