private void btnProbarConexionR_Click(object sender, EventArgs e) { if (txtServer.Text != "" && txtDB.Text != "" && txtLogin.Text != "" && txtPassword.Text != "") { using (SqlConnection conn = new SqlConnection(String.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", txtServer.Text, txtDB.Text, txtLogin.Text, txtPassword.Text))) { try { conn.Open(); XtraMessageBox.Show("Conexion Exitosa DB Local"); MSRegistro RegIn = new MSRegistro(); Crypto EncriptarTexto = new Crypto(); RegIn.SaveSetting("ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text)); RegIn.SaveSetting("ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text)); RegIn.SaveSetting("ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text)); RegIn.SaveSetting("ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text)); CargarComboSucursales(); } catch (Exception ex) { XtraMessageBox.Show("No se pudo Conectar con la Base de Datos Local: " + ex); } } } }
private void btnGuardarConexion_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (txtServer.Text != "" && txtDB.Text != "" && txtLogin.Text != "" && txtPassword.Text != "") { { SqlConnection conn = new SqlConnection("Data Source=" + txtServer.Text + ";Initial Catalog=" + txtDB.Text + ";Persist Security Info=True;User ID=" + txtLogin.Text + ";Password="******"ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text)); RegIn.SaveSetting("ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text)); RegIn.SaveSetting("ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text)); RegIn.SaveSetting("ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text)); XtraMessageBox.Show("Se Grabaron los Datos Del Servidor Principal Con Exito"); this.Close(); } catch (Exception ex) { XtraMessageBox.Show("Error Descripcion: " + ex); } } } else { XtraMessageBox.Show("Faltan Datos para la Conexion Principal"); } }
private void btnGuardarConexionR_Click(object sender, EventArgs e) { if (txtServer.Text != "" && txtDB.Text != "" && txtLogin.Text != "" && txtPassword.Text != "" && cboCajas.EditValue != null && cboSucursales.EditValue != null) { { SqlConnection conn = new SqlConnection("Data Source=" + txtServer.Text + ";Initial Catalog=" + txtDB.Text + ";Persist Security Info=True;User ID=" + txtLogin.Text + ";Password="******"ConexionSQL", "Server", EncriptarTexto.Encriptar(txtServer.Text)); RegIn.SaveSetting("ConexionSQL", "DBase", EncriptarTexto.Encriptar(txtDB.Text)); RegIn.SaveSetting("ConexionSQL", "User", EncriptarTexto.Encriptar(txtLogin.Text)); RegIn.SaveSetting("ConexionSQL", "Password", EncriptarTexto.Encriptar(txtPassword.Text)); RegIn.SaveSetting("ConexionSQL", "Sucursal", EncriptarTexto.Encriptar(cboSucursales.EditValue.ToString())); RegIn.SaveSetting("ConexionSQL", "Caja", EncriptarTexto.Encriptar(cboCajas.EditValue.ToString())); XtraMessageBox.Show("Se Grabaron los Datos Del Servidor Local Con Exito"); MSRegistro RegOut = new MSRegistro(); CargarComboSucursales(); this.Close(); } catch (Exception ex) { XtraMessageBox.Show("Error Descripcion: " + ex); } } } else { XtraMessageBox.Show("Faltan Datos para la Conexion Local"); } }