private void PopulateServers(ConnectionParams defaultParams) { _cpList.Clear(); int serverIndex = -1; bool defaultIsInList = false; ConnectionParamsCollection cons = Connections; foreach (ConnectionParams cp in cons) { string key = ConnectionParams.PrepareConnKey(cp); if (cmbServers.Items.Contains(key)) continue; cmbServers.Items.Add(key); if (defaultParams != null && defaultParams.Server.ToLowerInvariant() == cp.Server.ToLowerInvariant()) { cmbServers.SelectedIndex = cmbServers.Items.Count - 1; serverIndex = cmbServers.SelectedIndex; defaultIsInList = true; } _cpList.Add(cp); } if (!defaultIsInList) { cmbServers.Items.Add(defaultParams.Server); cmbServers.SelectedIndex = cmbServers.Items.Count - 1; _cpList.Add(defaultParams); } }
private void PopulateDBConnections() { _connParams = ConnectionParamsFactory.GetConnections(); lvConnections.Items.Clear(); foreach (ConnectionParams connSpec in _connParams) { ListViewItem item; if (connSpec.FriendlyName == null || connSpec.FriendlyName.Length == 0) { item = new ListViewItem(connSpec.Name); } else { item = new ListViewItem(connSpec.Name + " { " + connSpec.FriendlyName + " } "); } item.SubItems.Add(connSpec.InitialCatalog); item.Checked = connSpec.IsConnected; item.Tag = connSpec.ID; lvConnections.Items.Add(item); } if (_connParams.Count > 0) { lvConnections.Items[0].Selected = true; } InvalidateButtons(); }
private void PopulateServers(string defaultServerName) { cmbServers.Items.Clear(); if (_conn.State != ConnectionState.Open) { return; } int serverIndex = -1; _connParamsCollection = ConnectionParamsFactory.GetConnections(); foreach (ConnectionParams cp in _connParamsCollection) { cmbServers.Items.Add(cp.Name); if (defaultServerName.ToLowerInvariant() == cp.Name.ToLowerInvariant()) { cmbServers.SelectedIndex = cmbServers.Items.Count - 1; serverIndex = cmbServers.SelectedIndex; } } if (serverIndex == -1) { cmbServers.Items.Add(defaultServerName); cmbServers.SelectedIndex = cmbServers.Items.Count - 1; } }
private void PopulateServers() { _cpList.Clear(); ConnectionParamsCollection cons = Connections; foreach (ConnectionParams cp in cons) { //if (cmbServers.FindStringExact(cp.Server) != -1) if (cmbServers.FindStringExact(ConnectionParams.PrepareConnKey(cp)) != -1) { continue; } //cmbServers.Items.Add(cp.Server); cmbServers.Items.Add(ConnectionParams.PrepareConnKey(cp)); _cpList.Add(cp); } cmbServers.Text = "<Select Server>"; _currentServerIndex = -1; }