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", "ServerL")); ValDBase = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBaseL")); ValUser = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "UserL")); ValPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "PasswordL")); StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", ValServer, ValDBase, ValUser, ValPass); return(StrConexion); } catch (Exception ex) { throw new Exception(ex.Message); } }
public string LeerConexionR() { try { string StrConexion; string ValServerR; string ValDBaseR; string ValUserR; string ValPassR; MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); ValServerR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "ServerR")); ValDBaseR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "DBaseR")); ValUserR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "UserR")); ValPassR = DesencriptarTexto.Desencriptar(RegOut.GetSetting(NombreProyecto, "ConexionSQL", "PasswordR")); StrConexion = "Data Source=" + ValServerR + ";Initial Catalog=" + ValDBaseR + ";Persist Security Info=True;User ID=" + ValUserR + ";Password=" + ValPassR; return(StrConexion); } catch (Exception ex) { throw new Exception(ex.Message); } }
static public string LeerConexionC() { string StrConexion = string.Empty; string valServer = string.Empty; string valDB = string.Empty; string valLogin = string.Empty; string valPass = string.Empty; string ProyectName = string.Empty; try { StrConexion = string.Empty; valServer = ConfigurationManager.AppSettings["ServerName"].ToString(); valDB = ConfigurationManager.AppSettings["DataBase"].ToString(); valLogin = ConfigurationManager.AppSettings["UserName"].ToString(); valPass = ConfigurationManager.AppSettings["Password"].ToString(); ProyectName = ConfigurationManager.AppSettings["ProyectName"].ToString(); StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass); //SqlConnection conn = new SqlConnection(StrConexion); //conn.Open(); return(StrConexion); } catch { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); valServer = RegOut.GetSetting("ConexionSQL", "ServerC"); valDB = RegOut.GetSetting("ConexionSQL", "DBaseC"); valLogin = RegOut.GetSetting("ConexionSQL", "UserC"); valPass = RegOut.GetSetting("ConexionSQL", "PasswordC"); if (valServer != string.Empty && valDB != string.Empty && valLogin != string.Empty && valPass != string.Empty) { valServer = DesencriptarTexto.Desencriptar(valServer); valDB = DesencriptarTexto.Desencriptar(valDB); valLogin = DesencriptarTexto.Desencriptar(valLogin); valPass = DesencriptarTexto.Desencriptar(valPass); } else { valServer = string.Empty; valDB = string.Empty; valLogin = string.Empty; valPass = string.Empty; ProyectName = string.Empty; throw new Exception("Faltan datos de Conexion"); } StrConexion = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", valServer, valDB, valLogin, valPass); return(StrConexion); } }
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(string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", ValServer, ValDBase, ValUser, ValPass)); conn.Open(); return(true); } catch { return(false); } } else { return(false); } } catch { return(false); } }
public void ConnectionStrings(string csName) { MSRegistro RegOut = new MSRegistro(); Crypto DesencriptarTexto = new Crypto(); string valServer = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "ServerL")); string valDB = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "DBaseL")); string valLogin = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "UserL")); string valPass = DesencriptarTexto.Desencriptar(RegOut.GetSetting("ConexionSQL", "PasswordL")); String cadenaNueva = string.Format(@"XpoProvider=MSSqlServer;data source={0};user id={1}; password={2};initial catalog={3};Persist Security Info=true", valServer, valLogin, valPass, valDB); // Get the application configuration file. Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); int connStrCnt = ConfigurationManager.ConnectionStrings.Count; ConnectionStringSettings csSettings = new ConnectionStringSettings(csName, cadenaNueva); ConnectionStringsSection csSection = config.ConnectionStrings; config.ConnectionStrings.ConnectionStrings.Remove(csName); config.Save(ConfigurationSaveMode.Modified); csSection.ConnectionStrings.Add(csSettings); config.Save(ConfigurationSaveMode.Modified); ConfigurationManager.RefreshSection("ConnectionStrings"); }
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"); } }