dynamiccreatetable.h

动态创建数据库

#if !defined(AFX_DYNAMICCREATETABLE_H__DEC9248E_A9B2_4ED2_A5AE_1D31D1757958__INCLUDED_)
#define AFX_DYNAMICCREATETABLE_H__DEC9248E_A9B2_4ED2_A5AE_1D31D1757958__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// DynamicCreateTable.h : header file
//
typedef struct _TABLE_OBJ
{
	CString Table;
	CString ColumnName1;
	CString ColumnName2;
	//可以再这里面做成一个容器
}TABLEBOJ;


/////////////////////////////////////////////////////////////////////////////
// CDynamicCreateTable dialog

class CDynamicCreateTable : public CDialog
{
// Construction
public:
	CDynamicCreateTable(CWnd* pParent = NULL);   // standard constructor
	void ShowDatabaseList();
	_ConnectionPtr pConn;
	_RecordsetPtr  pRst;
    _CommandPtr    pComm;
    HRESULT m_hrConn; //是否创建实例
	CMapStringToOb  m_ToCreateTableList;
	CString m_strColumnToCreate1;
	CString m_strColumnToCreate2;
	CString m_strTableNameToCreate;
// Dialog Data
	//{{AFX_DATA(CDynamicCreateTable)
	enum { IDD = IDD_TABLE_DIALOG };
	CButton	m_ctrlEditToAdd;
	CComboBox	m_ctrlColumnAttribute2;
	CComboBox	m_ctrlColumnAttribute1;
	CEdit	m_ctrlTableName;
	CEdit	m_ctrlSearchState;
	CListBox	m_ctrlAddedList;
	CListBox	m_ctrlToAddList;
	CComboBox	m_ctrlSelectDatabase;
	CString	m_strTableName;
	CString	m_strSelectDatabase;
	CString	m_strSearchState;
	CString	m_strColumn1;
	CString	m_strColumn2;
	CString	m_strColumnAttribute1;
	CString	m_strColumnAttribute2;
	//}}AFX_DATA


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

// Implementation
protected:

	// Generated message map functions
	//{{AFX_MSG(CDynamicCreateTable)
	afx_msg void OnExit();
	afx_msg void OnSelchangeSelectdatabase();
	virtual BOOL OnInitDialog();
	afx_msg void OnEdittoadd();
	afx_msg void OnBegincreation();
	afx_msg void OnAddall();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_DYNAMICCREATETABLE_H__DEC9248E_A9B2_4ED2_A5AE_1D31D1757958__INCLUDED_)