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) { // } }