private void ShowSavedConnectionSettings() { switch (TypeDataBase.ToLower()) { case "postgresql": var builderPostgreSql = new NpgsqlConnectionStringBuilder(ConnectionStringManager.GetFirstConnectionString()); connectionServerTextEdit.EditValue = builderPostgreSql.Host; connectionDatabaseTextEdit.EditValue = builderPostgreSql.Database; connectionUsernameTextEdit.Text = builderPostgreSql.UserName; connectionPasswordTextEdit.Text = System.Text.Encoding.UTF8.GetString(builderPostgreSql.PasswordAsByteArray); break; case "sqlserver": var builderSqlServer = new SqlConnectionStringBuilder(ConnectionStringManager.GetFirstConnectionString()); connectionServerTextEdit.EditValue = builderSqlServer.DataSource; connectionDatabaseTextEdit.EditValue = builderSqlServer.InitialCatalog; connectionUsernameTextEdit.Text = builderSqlServer.UserID; connectionPasswordTextEdit.Text = builderSqlServer.Password; break; } }
public DatosServidor() { TypeDataBase = ConfigurationManager.AppSettings.Get("TypeDataBase"); ConnectionString = ConnectionStringManager.GetFirstConnectionString(); }
private void cmdAceptar_Click(object sender, EventArgs e) { string connectionString = null; switch (TypeDataBase.ToLower()) { case "postgresql": var builderPostgreSql = new NpgsqlConnectionStringBuilder { Host = connectionServerTextEdit.EditValue.ToString(), Database = connectionDatabaseTextEdit.EditValue.ToString(), UserName = connectionUsernameTextEdit.EditValue.ToString(), Password = connectionPasswordTextEdit.EditValue.ToString() }; connectionString = string.Format("Server={0};Port=5432;Database={1};User ID={2};Password={3};", builderPostgreSql.Host, builderPostgreSql.Database, builderPostgreSql.UserName, System.Text.Encoding.UTF8.GetString(builderPostgreSql.PasswordAsByteArray)); //Probar cadena de conexion para postgresql try { var connection = new NpgsqlConnection(connectionString); connection.Open(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Error de conexión", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } break; case "sqlserver": var builderSqlServer = new SqlConnectionStringBuilder { DataSource = connectionServerTextEdit.EditValue.ToString(), InitialCatalog = connectionDatabaseTextEdit.EditValue.ToString(), UserID = connectionUsernameTextEdit.EditValue.ToString(), Password = connectionPasswordTextEdit.EditValue.ToString() }; connectionString = string.Format("Server={0};Database={1};User ID={2};Password={3};", builderSqlServer.DataSource, builderSqlServer.InitialCatalog, builderSqlServer.UserID, builderSqlServer.Password); //Probar cadena de conexion para postgresql try { var connection = new SqlConnection(connectionString); connection.Open(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Error de conexión", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } break; } ConnectionStringManager.SaveConnectionString("MainConnection", Cryptography.EncryptStringAes(connectionString)); ConfigurationManager.RefreshSection("connectionStrings"); IsConfig = true; XtraMessageBox.Show("Se actualizo la información de conexion", "Configuración de conexion", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); }
public static string GetFirstConnectionString() { return(ConnectionStringManager.GetConnectionString(GetFirstConnectionStringName())); }