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;
}
