public void ReadFile()
{
//Then access the command line args from your form ...
string path = Program.CommandLineArgs[0];
ExeConfigurationFileMap configMap = new ExeConfigurationFileMap();
configMap.ExeConfigFilename = path;
config = ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None);
connectionStringObject = new ConnectionStringClass();
connectionStringObject.connectionStrings = new List <connectionString>();
ConnectionStringSettingsCollection connections = config.ConnectionStrings.ConnectionStrings;
if (connections.Count != 0)
{
foreach (ConnectionStringSettings connection in connections)
{
connectionString cs = new connectionString();
cs.Name = connection.Name;
cs.Provider = connection.ProviderName;
cs.ConnectionString = connection.ConnectionString;
connectionStringObject.connectionStrings.Add(cs);
}
}
connectionStringsList = connectionStringObject.connectionStrings;
}
private void SaveButton_Click(object sender, EventArgs e)
{
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
connectionString newCS = connectionStringsList.Single(p => p.Name == this.comboBox1.GetItemText(this.comboBox1.SelectedItem));
//newCS.ConnectionString =
// Set the properties for the data source.
sqlBuilder.DataSource = NewServer;
sqlBuilder.InitialCatalog = NewDb;
sqlBuilder.IntegratedSecurity = true;
// Build the SqlConnection connection string.
string providerString = sqlBuilder.ToString();
newCS.ConnectionString = providerString;
newCS.Name = NameTextBox.Text;
newCS.Provider = PNTextBox.Text;
//// Initialize the EntityConnectionStringBuilder.
//EntityConnectionStringBuilder entityBuilder =
//new EntityConnectionStringBuilder();
////Set the provider name.
//entityBuilder.Provider = providerName;
//// Set the provider-specific connection string.
//entityBuilder.ProviderConnectionString = providerString;
//// Set the Metadata location.
//entityBuilder.Metadata = @"res://*/AdventureWorksModel.csdl|
// res://*/AdventureWorksModel.ssdl|
// res://*/AdventureWorksModel.msl";
//Console.WriteLine(entityBuilder.ToString());
//using (EntityConnection conn =
//new EntityConnection(entityBuilder.ToString()))
//{
// conn.Open();
// Console.WriteLine("Just testing the connection.");
// conn.Close();
//}
Configuration Config1 = config;
ConnectionStringsSection conSetting = (ConnectionStringsSection)Config1.GetSection("connectionStrings");
ConnectionStringSettings StringSettings = new ConnectionStringSettings(newCS.Name, newCS.ConnectionString, newCS.Provider);
conSetting.ConnectionStrings.Remove(StringSettings);
conSetting.ConnectionStrings.Add(StringSettings);
Config1.Save(ConfigurationSaveMode.Modified);
ClearFormData();
}
