private void GetSQLDetails(ListBox SQLListBox) { SQLInfoEnumerator sie = new SQLInfoEnumerator(); try { if (SQLListBox.Name == "listboxSQLServerDatabaseInstances") { SQLListBox.Items.Clear(); sie.SQLServer = listboxSQLServerInstances.SelectedItem.ToString(); sie.Username = textboxUserName.Text; sie.Password = textboxPassword.Text; SQLListBox.Items.AddRange(sie.EnumerateSQLServersDatabases()); } else { SQLListBox.Items.Clear(); SQLListBox.Items.AddRange(sie.EnumerateSQLServers()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void buttonConnectServer_Click(object sender, EventArgs e) { progressBarServer.Visible = true; progressBarServer.Value = 50; SQLInfoEnumerator sie = new SQLInfoEnumerator(); try { buttonConnectServer.Enabled = false; string[] listServers = sie.EnumerateSQLServers(); if (listServers != null) { progressBarServer.Value = 80; comboBoxServerName.Items.Clear(); comboBoxServerName.Items.AddRange(listServers); } progressBarServer.Value = 100; buttonConnectServer.Enabled = true; progressBarServer.Visible = false; } catch (Exception ex) { buttonConnectServer.Enabled = true; progressBarServer.Visible = false; MessageBox.Show(ex.ToString()); } }
private void _DetectServers() { Cursor = Cursors.WaitCursor; var sie = new SQLInfoEnumerator(); cbServerName.Items.Clear(); cbServerName.Items.AddRange(sie.EnumerateSQLServers()); Cursor = Cursors.Default; }
private void buttonTest_Click(object sender, EventArgs e) { object[] databases; if (SQLInfoEnumerator.TestConnection(this.textBoxConnectionString.Text, out databases)) { buttonMysqlTest.Enabled = true; MessageBox.Show(this, "Database Connection Successful."); this.comboBoxDatabase.Items.Clear(); this.comboBoxDatabase.Items.AddRange(databases); } else { buttonMysqlTest.Enabled = false; MessageBox.Show(this, "Failed to Connect to Database"); } SaveSettingsMSSQL(); }
public List <SqlDatabaseSettings> GetSQLDatabasesSettings(string pDatabaseServerName, string pDatabaseLoginName, string pDatabasePassword) { SqlConnection connection = ConnectionManager.GeneralSqlConnection; try { connection.Open(); SQLInfoEnumerator sie = new SQLInfoEnumerator { SQLServer = pDatabaseServerName, Username = pDatabaseLoginName, Password = pDatabasePassword }; List <SqlDatabaseSettings> list = new List <SqlDatabaseSettings>(); foreach (string database in sie.EnumerateSQLServersDatabases()) { SqlDatabaseSettings sqlDatabase = _GetDatabaseInfos(database, connection); if (sqlDatabase == null) { continue; } list.Add(sqlDatabase); } connection.Close(); List <string> filter = TechnicalSettings.AvailableDatabases; return(list.FindAll(db => 0 == filter.Count || filter.Contains(db.Name))); } catch (Exception) { connection.Close(); throw; } }
private void FormMSSQLConnectionString() { textBoxConnectionString.Text = SQLInfoEnumerator.BuildConnectionstring(comboBoxServerName.Text, comboBoxDatabase.Text, comboBoxUserName.Text, textBoxPassword.Text, ((KeyValuePair)comboBoxAuthentication.SelectedItem).BoolValue); }