public string LeerConexionL() { try { string StrConexion; string ValServer; string ValDBase; string ValUser; string ValPass; MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); ValServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Server")); ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBase")); ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "User")); ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Password")); StrConexion = "Data Source=" + ValServer + ";Initial Catalog=" + ValDBase + ";Persist Security Info=True;User ID=" + ValUser + ";Password=" + ValPass; return(StrConexion); } catch (Exception ex) { throw new Exception(ex.Message); } }
public Boolean ValidaConexion() { try { string ValServer; string ValDBase; string ValUser; string ValPass; MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); try { ValServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Server")); ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBase")); ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "User")); ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "Password")); } catch { ValServer = string.Empty; ValDBase = string.Empty; ValUser = string.Empty; ValPass = string.Empty; } if (ValServer != string.Empty && ValDBase != string.Empty && ValUser != string.Empty && ValPass != string.Empty) { try { SqlConnection conn = new SqlConnection("Data Source=" + ValServer + ";Initial Catalog=" + ValDBase + ";Persist Security Info=True;User ID=" + ValUser + ";Password=" + ValPass); conn.Open(); return(true); } catch { return(false); } } else { return(false); } } catch { return(false); } }
private void Frm_Conexiones_Load(object sender, EventArgs e) { CargarIconos(); MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); string valServer, valDB, valLogin, valPass; try { valServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Server")); valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "DBase")); valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "User")); valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Password")); } catch { valServer = string.Empty; valDB = string.Empty; valLogin = string.Empty; valPass = string.Empty; } if (valServer != null && valDB != null && valLogin != null & valPass != null) { txtServer.Text = valServer; txtDB.Text = valDB; txtLogin.Text = valLogin; txtPassword.Text = valPass; 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(); } catch { XtraMessageBox.Show("No se Han Configurado datos Correctos para la conexion a la base de datos"); } } } else { txtServer.Text = string.Empty; txtDB.Text = string.Empty; txtLogin.Text = string.Empty; txtPassword.Text = string.Empty; } }
static public string LeerConexion() { string StrConexion; string valServer; string valDB; string valLogin; string valPass; try { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); valServer = RegOut.GetSetting("ConexionSQL", "Server"); valDB = RegOut.GetSetting("ConexionSQL", "DBase"); valLogin = RegOut.GetSetting("ConexionSQL", "User"); valPass = RegOut.GetSetting("ConexionSQL", "Password"); if (valServer != string.Empty && valLogin != string.Empty && valLogin != string.Empty && valPass != string.Empty) { valServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Server")); valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "DBase")); valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "User")); valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "Password")); } else { throw new Exception("Faltan datos para la Conexión"); } } catch { valServer = string.Empty; valDB = string.Empty; valLogin = string.Empty; valPass = string.Empty; } if (valServer != string.Empty && valLogin != string.Empty && valLogin != string.Empty && valPass != string.Empty) { StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass); return(StrConexion); } else { throw new Exception("Faltan datos para la Conexión"); } }