selecttable.cpp

实现ADO连接SQL SERVER 2000数据库

// SelectTable.cpp : implementation file
//

#include "stdafx.h"
#include "ADO.h"
#include "SelectTable.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CADOApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CSelectTable dialog
CString tmp;

CSelectTable::CSelectTable(CWnd* pParent /*=NULL*/)
	: CDialog(CSelectTable::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSelectTable)
	m_combo = _T("");
	//}}AFX_DATA_INIT
}


void CSelectTable::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSelectTable)
	DDX_Control(pDX, IDC_COMBO1, m_combo1);
	DDX_CBString(pDX, IDC_COMBO1, m_combo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSelectTable, CDialog)
	//{{AFX_MSG_MAP(CSelectTable)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSelectTable message handlers

void CSelectTable::OnOK() 
{
	// TODO: Add extra validation here
	int i = m_combo1.GetCurSel();
	m_combo1.GetLBText(i,tmp);
	CDialog::OnOK();
}

BOOL CSelectTable::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	// 打开数据库
	_variant_t vID;
	int i = 0;
	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		//用SQL语句打开数据库“SELECT * FROM 表1” //name like '表%' and 
		m_pRecordset->Open("select name from sysobjects where xtype='U'", _variant_t((IDispatch*)theApp.m_pConnection,true), adOpenStatic, adLockOptimistic, adCmdText);
		while(!m_pRecordset->adoEOF)
		{
			vID = (_bstr_t)(m_pRecordset->Fields->GetItem(_variant_t("Name"))->Value);
			m_combo = vID.bstrVal;
			m_combo1.AddString(m_combo);
			m_pRecordset->MoveNext();
		}
	}
	catch(_com_error e)///捕捉异常
	{
		AfxMessageBox("读取数据库失败!");///显示错误信息
	}
	
	m_pRecordset->Close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}