private void PopulateServerNames()
{
if (this.refreshServerListOnDropDown)
{
this.Cursor = Cursors.WaitCursor;
Application.DoEvents();
ArrayList servers = SqlServerLocator.FindServers();
SQLServerComboBox.Items.Clear();
if (servers != null)
{
foreach (string server in servers)
{
if (server.ToLower() == "(local)")
{
SQLServerComboBox.Items.Add(Environment.MachineName.ToUpper());
}
else
{
SQLServerComboBox.Items.Add(server);
}
}
SQLServerComboBox.SelectedItem = SQLServerComboBox.Items[0];
}
this.Cursor = Cursors.Default;
this.refreshServerListOnDropDown = false;
}
}
private void PopulateDatabaseNamesList()
{
if (this.SQLServerComboBox.Text != null && this.SQLServerComboBox.Text.Length > 0)
{
this.SQLDatabaseComboBox.Enabled = false;
this.SQLDatabaseComboBox.SelectedItem = null;
this.SQLDatabaseComboBox.Text = "Querying available databases...";
this.SQLDatabaseComboBox.Items.Clear();
Application.DoEvents();
Cursor.Current = Cursors.WaitCursor;
string serverName = this.SQLServerComboBox.Text as string;
foreach (string databaseName in SqlServerLocator.FindDatabases(serverName))
{
// Do not allow any of these specified databases
if (string.Compare(databaseName, "master", true) != 0 &&
string.Compare(databaseName, "msdb", true) != 0 &&
string.Compare(databaseName, "tempdb", true) != 0 &&
string.Compare(databaseName, "model", true) != 0)
{
this.SQLDatabaseComboBox.Items.Add(databaseName.ToUpper());
}
}
// Set the initial database
if (this.SQLDatabaseComboBox.Items.Count > 0)
{
// Do we have a pre loaded database name?
if (this.initialCatalog != null && this.initialCatalog.Length > 0 && this.SQLDatabaseComboBox.Items.Contains(this.initialCatalog))
{
// Yes, set it
this.DatabaseName = this.initialCatalog;
}
else
{
// No, then set the first item
this.SQLDatabaseComboBox.SelectedItem = this.SQLDatabaseComboBox.Items[0];
}
}
else
{
// No DB's returned, clear this out then
this.DatabaseName = "";
}
if (this.SQLSelectDatabaseRadioButton.Checked)
{
this.SQLDatabaseComboBox.Enabled = true;
}
Cursor.Current = Cursors.Default;
}
}
