// Occurs when the user chooses to test their database connection. private void TestConnectionButton_Click(object sender, RoutedEventArgs e) { try { SqlServerSetup testSqlServerSetup = new SqlServerSetup(); testSqlServerSetup.ConnectionString = m_sqlServerSetup.ConnectionString; testSqlServerSetup.DataProviderString = m_sqlServerSetup.DataProviderString; testSqlServerSetup.DatabaseName = null; testSqlServerSetup.Timeout = "5"; using (AdoDataConnection connection = testSqlServerSetup.OpenConnection()) { } MessageBox.Show("Database connection succeeded."); } catch { string failMessage = "Database connection failed." + " Please check your username and password." + " Additionally, you may need to modify your connection under advanced settings."; MessageBox.Show(failMessage); } }
// Occurs when the user chooses to test their database connection. private void TestConnectionButton_Click(object sender, RoutedEventArgs e) { IDbConnection connection = null; string databaseName = null; try { databaseName = m_sqlServerSetup.DatabaseName; m_sqlServerSetup.DatabaseName = null; m_sqlServerSetup.OpenConnection(ref connection); MessageBox.Show("Database connection succeeded."); } catch { string failMessage = "Database connection failed." + " Please check your username and password." + " Additionally, you may need to modify your connection under advanced settings."; MessageBox.Show(failMessage); } finally { if (connection != null) { connection.Dispose(); } if (databaseName != null) { m_sqlServerSetup.DatabaseName = databaseName; } } }