示例#1
0
        private void SQLServerComboBox_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            if (this.SQLServerComboBox.SelectedItem != null && this.SQLServerComboBox.SelectedItem is string)
            {
                this.SQLDatabaseComboBox.Enabled      = false;
                this.SQLDatabaseComboBox.SelectedItem = null;
                this.SQLDatabaseComboBox.Text         = "";
                this.SQLDatabaseComboBox.Items.Clear();
                Application.DoEvents();
                Cursor.Current = Cursors.WaitCursor;

                string serverName = this.SQLServerComboBox.SelectedItem as string;

                foreach (string databaseName in SqlServerLocator.FindDatabases(serverName))
                {
                    this.SQLDatabaseComboBox.Items.Add(databaseName);
                }

                if (this.SQLDatabaseComboBox.Items.Count > 0)
                {
                    this.SQLDatabaseComboBox.SelectedItem = this.SQLDatabaseComboBox.Items[0];
                }

                this.SQLDatabaseComboBox.Enabled = true;
                Cursor.Current = Cursors.Default;
            }
        }
示例#2
0
        private void SQLServerComboBox_DropDown(object sender, System.EventArgs e)
        {
            if (this.refreshServerListOnDropDown)
            {
                this.Cursor = Cursors.WaitCursor;
                Application.DoEvents();

                ArrayList servers = SqlServerLocator.FindServers();
                SQLServerComboBox.Items.Clear();

                foreach (string server in servers)
                {
                    if (server.ToLower() == "(local)")
                    {
                        SQLServerComboBox.Items.Add(Environment.MachineName.ToUpper());
                    }
                    else
                    {
                        SQLServerComboBox.Items.Add(server);
                    }
                }

                this.Cursor = Cursors.Default;
                this.refreshServerListOnDropDown = false;
            }
        }