private IFrmMain frmMain = null; //主窗体 #endregion #region [ 事件: 窗体加载 ] /// <summary> /// 窗体加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmSqlList_Load(object sender, EventArgs e) { SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); //分布式管理对象 try { SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers();//获取服务器名称列表 if (serverList.Count > 0) { for (int i = 1; i <= serverList.Count; i++) { ltbServer.Items.Add(serverList.Item(i));//绑定到ListBox } } else { ltbServer.Items.Add("(local)"); //如果没有活动的服务器,加载本机 } ltbServer.SelectedIndex = 0; } catch (Exception ex) { ErrorMessage(3010010, ex.StackTrace, "[FrmDBSet:LoadSqlList]", ex.Message); //3010010frmMain.ErrorMessage(ee.Message, true, false); } finally { sqlApp.Quit(); } }
// 在用户的配置时,我们需要列出当前局域网内所有的数据库服务器,并且要列出指定服务器的所有数据库,实现代码如下: // 取得数据库服务器列表: /// <summary> /// 获取数据库服务器列表 /// </summary> /// <returns></returns> public static ArrayList GetServerList(out bool isErr) { ArrayList allServers = new ArrayList(); try { SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); // 将局域网类的所有能够连接SQL的服务器名称列出 SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers(); allServers.Add("(local)"); for (int i = 1; i <= serverList.Count; i++) { // 添加到列表中 allServers.Add(serverList.Item(i)); } sqlApp.Quit(); isErr = true; } catch (Exception e) { isErr = SqlErrRepair(e.Message.ToString()); return GetServerList(out isErr); } return allServers; }
private void FillDBServer() { if (cbxDBServerList.Items.Count == 0) { SQLDMO.NameList names; SQLDMO.ApplicationClass ac = new SQLDMO.ApplicationClass(); names = ac.ListAvailableSQLServers(); string[] serverList = new string[names.Count]; for (int i = 0; i < serverList.Length; i++) { serverList[i] = names.Item(i); } foreach (string severName in serverList) { if (severName != null) { cbxDBServerList.Items.Add(severName); } } } }
// 在用户的配置时,我们需要列出当前局域网内所有的数据库服务器,并且要列出指定服务器的所有数据库,实现代码如下: // 取得数据库服务器列表: /// <summary> /// 获取数据库服务器列表 /// </summary> /// <returns></returns> public static ArrayList GetServerList(out bool isErr) { ArrayList allServers = new ArrayList(); try { SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); // 将局域网类的所有能够连接SQL的服务器名称列出 SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers(); allServers.Add("(local)"); for (int i = 1; i <= serverList.Count; i++) { // 添加到列表中 allServers.Add(serverList.Item(i)); } sqlApp.Quit(); isErr = true; } catch (Exception e) { isErr = SqlErrRepair(e.Message.ToString()); return(GetServerList(out isErr)); } return(allServers); }
public ArrayList GetServerList() { ArrayList alServers = new ArrayList(); SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); try { SQLDMO.NameList serverList = sqlApp.ListAvailableSQLServers(); for (int i = 1; i <= serverList.Count; i++) { alServers.Add(serverList.Item(i)); //comboBox1.Items.Add(serverList.Item(i)); //listBox1.Items.Add(serverList.Item(i)); } } catch (Exception e) { throw (new Exception("Take the database server list error:" + e.Message)); } finally { sqlApp.Quit(); } return(alServers); }
/// <summary> /// Handles the DropDown event of the comboBoxSqlServer control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> private void comboBoxSqlServer_DropDown(object sender, EventArgs e) { comboBoxSqlServer.Items.Clear(); Application.UseWaitCursor = true; try { SQLDMO.ApplicationClass app = new SQLDMO.ApplicationClass(); SQLDMO.NameList servers = app.ListAvailableSQLServers(); for (int i = 1; i <= servers.Count; i++) { comboBoxSqlServer.Items.Add(servers.Item(i)); } } catch (Exception ex) { Trace.WriteLine(ex, "Mediachase.Ibn.ConfigurationUI.SQLDMO"); } Application.UseWaitCursor = false; }