public ArrayList GetServerList()
{
ArrayList arrayLists = new ArrayList();
SQLDMO.Application applicationClass = new Application();
try
{
try
{
NameList nameList = applicationClass.ListAvailableSQLServers();
for (int i = 1; i <= nameList.Count; i++)
{
arrayLists.Add(nameList.Item(i));
}
}
catch (Exception exception)
{
throw new Exception(string.Concat("取数据库服务器列表出错：", exception.Message));
}
}
finally
{
applicationClass.Quit();
}
return(arrayLists);
}
private void Form1_Load(object sender, EventArgs e)
{
SQLDMO.Application app = new SQLDMO.Application();
SQLDMO.NameList sqlList = app.ListAvailableSQLServers();
for (int i = 1; i < sqlList.Count; i++)
{
cmbServer.Items.Add(sqlList.Item(i));
}
SetText();
}
private void getSqlServer()
{//获取数据库服务器列表
SQLDMO.Application SQLServer = new SQLDMO.Application();
SQLDMO.NameList strServerList = SQLServer.ListAvailableSQLServers();
if (strServerList.Count > 0)
{
for (int i = 0; i < strServerList.Count; i++)
{
cbbSqlServerName.Items.Add(strServerList.Item(i + 1));//将找到的服务器添加到comboBox中显示
}
}
}
private void RemplirSQLServers()
{
try
{
// SQLDMO.NameList serverSql = SQLApp.ListAvailableSQLServers();
int i = 0;
ServerCombo.Items.Clear();
var listServeur = SQLApp.ListAvailableSQLServers();
foreach (var serverSql in listServeur)
{
ServerCombo.Items.Insert(i, serverSql);
SunriseServ.Items.Insert(i, serverSql);
// Suivant
i++;
}
ServerCombo.SelectedIndex = 0;
SunriseServ.SelectedIndex = 0;
}
catch (Exception e)
{
//
}
}
