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