/// <summary>
/// Add a connectionstring to the configuration file
/// </summary>
/// <param name="connectionString"></param>
public static void AddConnectionString(ConnectionStringStruct connectionString)
{
// Get the document
XmlDocument document = GetXmlDocument(GetConfigFile());
// Get the node wich contains all the connection strings
XmlNode parentNode = document.SelectSingleNode("configuration/connectionStrings");
// Create a new element
XmlElement newElement = document.CreateElement("add");
// Define the new attributes
XmlAttribute nameAttribute = document.CreateAttribute("name");
nameAttribute.Value = connectionString.name;
XmlAttribute connectionStringAttribute = document.CreateAttribute("connectionString");
connectionStringAttribute.Value = connectionString.connectionString;
XmlAttribute providerNameAttribute = document.CreateAttribute("providerName");
providerNameAttribute.Value = connectionString.providerName;
// Append them to the new element
newElement.Attributes.Append(nameAttribute);
newElement.Attributes.Append(connectionStringAttribute);
newElement.Attributes.Append(providerNameAttribute);
// Append the new element to the peren node
parentNode?.AppendChild(newElement);
// Save the document
document.Save(GetConfigFile());
}
/// <summary>
/// Edits the XML configuration file.
/// </summary>
/// <param name="dbName">Name of the database.</param>
/// <param name="providerName">Name of the provider.</param>
/// <param name="connectionString">The connection string.</param>
private void EditXmlConfigFile(string dbName, string providerName, string connectionString)
{
ConnectionStringStruct connStruct = Settings.GetConnectionString(dbName);
if (connStruct.Equals(new ConnectionStringStruct()))
{
connStruct.name = dbName;
connStruct.connectionString = connectionString;
connStruct.providerName = providerName;
Settings.AddConnectionString(connStruct);
}
else
{
connStruct.connectionString = connectionString;
connStruct.providerName = providerName;
Settings.RemoveConnectionString(dbName);
Settings.AddConnectionString(connStruct);
}
// Close the configuration form
Close();
}