public bool Set_NewConnectionItem(string Key, string Server, string UserID, string Password, string activeDB) { if (!ActiveSqlConnectionCollection.ContainsKey(Key)) { Data_SqlConnectionItemEntry newEntry = new Data_SqlConnectionItemEntry(); newEntry.Server = Server; newEntry.UserID = UserID; newEntry.Password = Password; newEntry.ActiveDataBase = activeDB; newEntry.ConnectionString = newEntry.ConnectionString.Replace("{server}", Server); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{uid}", UserID); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{pwd}", Password); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{db}", activeDB); newEntry.ActiveConnection = new SqlConnection(newEntry.ConnectionString); try { newEntry.ActiveConnection.Open(); ActiveSqlConnectionCollection.Add(Key, newEntry); return(true); } catch { return(false); } } else { return(false); } }
public bool Set_NewConnectionItem(string Key, string Server, string UserID, string Password, string activeDB) { if (!ActiveSqlConnectionCollection.ContainsKey(Key)) { Data_SqlConnectionItemEntry newEntry = new Data_SqlConnectionItemEntry(); newEntry.Server = Server; newEntry.UserID = UserID; newEntry.Password = Password; newEntry.ActiveDataBase = activeDB; newEntry.ConnectionString = newEntry.ConnectionString.Replace("{server}", Server); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{uid}", UserID); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{pwd}", Password); newEntry.ConnectionString = newEntry.ConnectionString.Replace("{db}", activeDB); newEntry.ActiveConnection = new SqlConnection(newEntry.ConnectionString); try { newEntry.ActiveConnection.Open(); ActiveSqlConnectionCollection.Add(Key, newEntry); return true; } catch { return false; } } else return false; }