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;
}
