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 AddNewConnectionSpec()
{
frmConnectionParams frm = new frmConnectionParams();
frm.TopMost = true;
if (frm.ShowDialog() == DialogResult.OK)
{
AddConnectionSpecToList(frm.GetCurrentConnectionSpec());
ConnectionParamsFactory.Save(_connParams);
InvalidateButtons();
}
}
private void EditSelectedConnectionSpec()
{
if (lvConnections.SelectedItems.Count == 0)
{
return;
}
frmConnectionParams frm = new frmConnectionParams(this.SelectedDataSource, true);
frm.TopMost = true;
if (frm.ShowDialog() == DialogResult.OK)
{
_connParams.Delete(this.SelectedDataSource);
lvConnections.Items.Remove(lvConnections.SelectedItems[0]);
AddConnectionSpecToList(frm.GetCurrentConnectionSpec());
ConnectionParamsFactory.Save(_connParams);
InvalidateButtons();
}
}
public frmRecoverContent()
{
InitializeComponent();
_connRep = ConnectionParamsFactory.EnumerateConnections();
}
public static MSSQLConnection CreateMssqlConnection(string server, string database, string username = null, string password = null)
{
return(new MSSQLConnection(ConnectionParamsFactory.CreateMssqlConnectionParams(server, database, username, password)));
}