Advertisement
Guest User

Untitled

a guest
Jun 30th, 2015
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
  2. int initialCount = ConfigurationManager.ConnectionStrings.Count;
  3. string connStringName = "TEST";
  4. string serverName="Servedr";
  5. string databaseName = "MyDb";
  6. string userId="MyUseId";
  7. string password="MyPassword";
  8. var connectionStringBuilder = new SqlConnectionStringBuilder
  9. {
  10. DataSource = serverName,
  11. InitialCatalog = databaseName,
  12. UserID = userId,
  13. Password = password
  14. };
  15.  
  16.  
  17. var csSetting = new ConnectionStringSettings(connStringName, connectionStringBuilder.ConnectionString, "System.Data.SqlClient");
  18. var csSection = config.ConnectionStrings;
  19. csSection.ConnectionStrings.Add(csSetting);
  20. config.Save(ConfigurationSaveMode.Modified, true);
  21. ConfigurationManager.RefreshSection("ConnectionStrings");
  22.  
  23. int finalCount = ConfigurationManager.ConnectionStrings.Count;
  24.  
  25. var csSetting = new ConnectionStringSettings(connStringName, connectionStringBuilder.ConnectionString, "System.Data.SqlClient");
  26.  
  27. var readonlyField = typeof(ConfigurationElementCollection).GetField("bReadOnly", BindingFlags.NonPublic | BindingFlags.Instance);
  28. readonlyField.SetValue(ConfigurationManager.ConnectionStrings, false);
  29.  
  30. var baseAddMethod = typeof(ConfigurationElementCollection).GetMethod("BaseAdd",
  31. BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[] { typeof(ConfigurationElement) }, null);
  32. baseAddMethod.Invoke(ConfigurationManager.ConnectionStrings, new object[] { csSetting });
  33.  
  34. readonlyField.SetValue(ConfigurationManager.ConnectionStrings, true);
  35.  
  36. int finalCount = ConfigurationManager.ConnectionStrings.Count;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement