vc中列举sqlserver服务器及数据库和使用语言.txt

一个学生考试成绩管理的半成品

void CSQLSrvEnumeratorDlg::OnDropdownCombosqlservers() 
{
	//Fill List of SQL Servers
	CWaitCursor wait;
	m_ctlServer.ResetContent();
	CSQLInfoEnumerator obSQLEnumerate;
	if(obSQLEnumerate.EnumerateSQLServers())
	{
		int iCount = obSQLEnumerate.m_szSQLServersArray.GetSize();
		for(int i = 0; i < iCount; i++)
		{
			m_ctlServer.AddString(obSQLEnumerate.m_szSQLServersArray[i]);
		}
	}
}

void CSQLSrvEnumeratorDlg::OnDropdownCombodatabase() 
{
	//Fill List of Databases
	CWaitCursor wait;
	m_ctlDatabase.ResetContent();
	UpdateData();
	CSQLInfoEnumerator obSQLEnumerate;

	if(obSQLEnumerate.EnumerateDatabase(m_szSQLServer,m_szUserId,m_szPassword))
	{
		int iCount = obSQLEnumerate.m_szSQLServerDatabaseArray.GetSize();
		for(int i = 0; i < iCount; i++)
		{
			m_ctlDatabase.AddString(obSQLEnumerate.m_szSQLServerDatabaseArray[i]);
		}
	}
}

void CSQLSrvEnumeratorDlg::OnDropdownCombolanguage() 
{
	//Fill List of languages
	CWaitCursor wait;
	m_ctlLanguage.ResetContent();
	UpdateData();
	CSQLInfoEnumerator obSQLEnumerate;

	if(obSQLEnumerate.EnumerateDatabaseLanguage(m_szSQLServer,m_szUserId,m_szPassword))
	{
		int iCount = obSQLEnumerate.m_szSQLServerLanguageArray.GetSize();
		for(int i = 0; i < iCount; i++)
		{
			m_ctlLanguage.AddString(obSQLEnumerate.m_szSQLServerLanguageArray[i]);
		}
	}
}