public DBManager(string ip, string port, string username, string password) { _ipAddr = ip; _port = port; _username = username; _encryptPassword = SysUtil.EncryptDES(password, password); _connectString = GetDBConnectionString(); string connectState = TestConnect(); if (connectState == "Open") { isConnectable = true; _state = "Connectable"; _errorMsg = "0"; } else { isConnectable = false; _errorMsg = connectState; } }
public string GetDBConnectionString() { string decryptedPassword = SysUtil.DecryptDES(_encryptPassword, "quality"); return(string.Format(@"Data Source={0},{1};Network Library=DBMSSOCN;Initial Catalog=qualityDB;User ID={2};Password={3};", _ipAddr, _port, _username, decryptedPassword)); }
public static string GetDBConnectionString(string ip, string port, string username, string encrptyPassword) { string decryptedPassword = SysUtil.DecryptDES(encrptyPassword, "quality"); return(string.Format(@"Data Source={0},{1};Network Library=DBMSSOCN;Initial Catalog=qualityDB;User ID={2};Password={3};", ip, port, username, decryptedPassword)); }