// 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;
}
}
}
