//获取SQL服务器列表 public ArrayList GetSqlServerList() { ArrayList list = new ArrayList(); SQLDMO.Application sqlApp = new SQLDMO.Application(); SQLDMO.NameList ServerName = sqlApp.ListAvailableSQLServers(); for (int i = 0; i < ServerName.Count; i++) { list.Add(ServerName.Item(i + 1)); } return(list); }
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)); } } }
private void Form2_Load(object sender, EventArgs e) { listBox1.Items.Clear(); SQLDMO.Application SQLServer = new SQLDMO.Application(); SQLDMO.NameList strServer = SQLServer.ListAvailableSQLServers(); if (strServer.Count > 0) { for (int i = 0; i < strServer.Count; i++) { listBox1.Items.Add(strServer.Item(i + 1)); } } }
private void buildServerMap() { sqlServersMap = new Dictionary<string, string>(); //get all available SQL Servers SQLDMO.Application sqlApp = new SQLDMO.Application(); SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers(); ArrayList servs = new ArrayList(); for (int i = 0; i < sqlServers.Count; i++) { object srv = sqlServers.Item(i + 1); if (srv != null) { sqlServersMap.Add(srv.ToString(), srv.ToString()); } } }
/// <summary> /// Get Server List By SQLDMO Com /// </summary> private void InitServerList() { this.cboxServerList.Items.Clear(); SQLDMO.Application sqlApp = new SQLDMO.Application(); SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers(); for (int i = 0; i < sqlServers.Count; i++) { object srv = sqlServers.Item(i + 1); if (srv != null) { this.cboxServerList.Items.Add(srv); } } if (this.cboxServerList.Items.Count > 0) { this.cboxServerList.SelectedIndex = 0; } else { this.cboxServerList.Text = "<No available SQL Servers>"; } }