private void buttonTestConnection_Click(object sender, EventArgs e) { string DatabaseEngine = this.database; SolidoSettings _settings = new SolidoSettings(); ConfigFilePath configfilepath = new ConfigFilePath(); configfilepath.PathFileConfig = filepathconfig; bool ok = false; try { string databaseTypeXml; appConfigurationDatabaseConnection _appConfigurationDB = _settings.GetConfigurationDatabaseConnection(configfilepath); databaseTypeXml = _util.DecryptRijndael(_appConfigurationDB.DatabaseType, ""); if (databaseTypeXml == "sQLSource") { _connectionString = "Data Source=" + _util.DecryptRijndael(_appConfigurationDB.ServerName, "") + ";Initial Catalog=" + _util.DecryptRijndael(_appConfigurationDB.DatabaseName, "") + ";Persist Security Info=True" + ";User ID=" + _util.DecryptRijndael(_appConfigurationDB.User, "") + ";Password="******"") + ";Pooling=False" + ";Connect Timeout=" + _util.DecryptRijndael(_appConfigurationDB.ConnectionTimeout, ""); SqlConnection sqlconn = new SqlConnection(_connectionString); sqlconn.Open(); sqlconn.Close(); sqlconn.Dispose(); ok = true; } else if (databaseTypeXml == "OracleSource") { _connectionString = "User ID=" + _util.DecryptRijndael(_appConfigurationDB.User, "") + ";Password="******"") + ";Data Source=" + _util.DecryptRijndael(_appConfigurationDB.ServerName, ""); OracleConnection Oraconn = new OracleConnection(_connectionString); Oraconn.Open(); Oraconn.Close(); Oraconn.Dispose(); ok = true; } } catch (Exception ex) { MessageBox.Show("Error de Conexion: " + ex.Message.ToString(), "Validación de Conexión", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (ok) { textBoxCadenaSolido.Text = _connectionString; MessageBox.Show("Conexion Exitosa!", "Validación de Conexión", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public appConfigurationDatabaseConnection GetConfigurationDatabaseConnection(ConfigFilePath configfilepath) { XmlDocument _xmlDocument = new XmlDocument(); _xmlDocument.Load(configfilepath.PathFileConfig); appConfiguration _appConfiguration = (appConfiguration)Deserialize(_xmlDocument, typeof(appConfiguration)); return(_appConfiguration.Database.DatabaseConnection); }