/// <summary> /// In the app.config file : /// for the connect string - UserID comes before dlr_debug and /// if you have dlr_debug, you need to include app_path /// ie: <add key="connect" value="item1=...;item2=...; User ID=apps;dlr_debug;"/> /// <add key="app_path" value="C:\...\...\MyApp"/> /// </summary> private Connection() { ConfigData.CreateInstance(); dBConnectStringBase = ConfigData.GetValue("connect"); //nwlrl_connect **!** also uncomment the password & User lines below if (dBConnectStringBase.IndexOf("dlr_debug") > 0) { //if 'debug' then provide the user name and pw string[] cnctStr = dBConnectStringBase.Split(';'); string userName = ""; string connectItems = ""; string app_path = ""; string pWord = ""; app_path = app_path.Length > 0 ? app_path : ConfigData.GetValue("app_path").ToString(); dBConnectStringBase = ""; needLogIn = false; for (int x = 0; x < cnctStr.Length; x++) { if (cnctStr[x].Length > 0) { connectItems = cnctStr[x].ToString().Trim().Substring(0, 6); if (connectItems.Equals("UserID") || connectItems.Equals("User I")) { string[] uid = cnctStr[x].ToString().Split('='); userName = uid[1]; } if (cnctStr[x].ToString().Trim().Equals("dlr_debug")) { if (userName.Length > 0) { Crypto cryptLogIn = new Crypto(app_path); cryptLogIn.Dbug = true; pWord = cryptLogIn.Decrypt(cryptLogIn.ReadFromFile(), userName).ToString(); if (pWord.Length > 0) { dBConnectStringBase += "User ID=" + userName + ";password="******";"; } } } dBConnectString = dBConnectStringBase; debug = true; } }