private void cmdTestConnection_Click(object sender, EventArgs e) { DatabaseConnectionControl1.RefreshOptions(); var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var valid = DatabaseHelper.TestConnectionString(connectString); if (valid) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmdTestConnection_Click(object sender, EventArgs e) { try { //SQL if (optDatabaseTypeSQL.Checked) { DatabaseConnectionControl1.RefreshOptions(); var connectString = DatabaseConnectionControl1.ImportOptions.GetConnectionString(); var importDomain = new nHydrate.DataImport.SqlClient.ImportDomain(); var databaseHelper = importDomain.DatabaseDomain; var valid = databaseHelper.TestConnectionString(connectString); if (valid) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (optDatabaseTypePostgres.Checked) //Postgres { if (DslPackage.Objects.Postgres.ImportDomain.TestConnection(txtConnectionStringPostgres.Text)) { MessageBox.Show("Connection Succeeded.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("The information does not describe a valid connection string.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Unknown database type.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("An error has occurred.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }