Click here to Skip to main content
15,886,788 members
Articles / Database Development / SQL Server

Database Visualization

Rate me:
Please Sign up or sign in to vote.
4.60/5 (11 votes)
31 May 20067 min read 81.6K   2.8K   77  
This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.
#if !defined(AFX_GENERATECODEDLG_H__382D37CD_4702_48DA_AD73_9515F2749D36__INCLUDED_)
#define AFX_GENERATECODEDLG_H__382D37CD_4702_48DA_AD73_9515F2749D36__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// GenerateCodeDlg.h : header file
//

/////////////////////////////////////////////////////////////////////////////
// CGenerateCodeDlg dialog

class CGenerateCodeDlg : public CPropertyPage
{
	DECLARE_DYNCREATE(CGenerateCodeDlg)

// Construction
public:
	CGenerateCodeDlg();
	~CGenerateCodeDlg();

	CString m_strQueryType;

	CString	GetUserComments();
	void	GetQueryType();
	void	GetSelectedTablesAndColumns(CString &strSqlQuery);
	void	GetWhereClause(CString &strSqlQuery);
	void	SaveSqlQuery(CString strSqlQuery);

// Dialog Data
	//{{AFX_DATA(CGenerateCodeDlg)
	enum { IDD = IDD_DLG_GENERATE_CODE };
		// NOTE - ClassWizard will add data members here.
		//    DO NOT EDIT what you see in these blocks of generated code !
	//}}AFX_DATA


// Overrides
	// ClassWizard generate virtual function overrides
	//{{AFX_VIRTUAL(CGenerateCodeDlg)
	public:
	virtual BOOL OnSetActive();
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	// Generated message map functions
	//{{AFX_MSG(CGenerateCodeDlg)
	afx_msg void OnBtnCreateQuery();
	afx_msg void OnBtnCreateDiagram();
	afx_msg void OnBtnGenerateVcCode();
	afx_msg void OnBtnGenerateVbCode();
	afx_msg void OnBtnGenerateCode();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()

};

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

#endif // !defined(AFX_GENERATECODEDLG_H__382D37CD_4702_48DA_AD73_9515F2749D36__INCLUDED_)

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Founder
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions