Beispiel #1
0
 private void btnGuardarConexionR_Click(object sender, EventArgs 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 Local Con Exito");
                 this.Close();
             }
             catch (Exception ex)
             {
                 XtraMessageBox.Show("Error Descripcion: " + ex);
             }
         }
     }
     else
     {
         XtraMessageBox.Show("Faltan Datos para la Conexion Local");
     }
 }
Beispiel #2
0
 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));
             }
             catch (Exception ex)
             {
                 XtraMessageBox.Show("No se pudo Conectar con la Base de Datos Local: " + ex);
             }
         }
     }
 }