How do I set a connection string config programmatically in .net?

by

I’ve written about this in a post on my blog. The trick is to use reflection to poke values in as a way to get access to the non-public fields (and methods).

eg.

var settings = ConfigurationManager.ConnectionStrings[ 0 ];

var fi = typeof( ConfigurationElement ).GetField( "_bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic );

fi.SetValue(settings, false);

settings.ConnectionString = "Data Source=Something";

More Related Contents:

  1. App.config connection string relative path
  2. Simplest way to have a configuration file in a Windows Forms C# application
  3. How to select different app.config for several build configurations
  4. How to modify .NET config files during installation?
  5. Using app.config with a class library
  6. .NET Config Files configSource outside the application directory folder
  7. Custom app.config Config Section Handler
  8. Connection string using Windows Authentication
  9. Encrypting connectionStrings section – utility for app.config
  10. What is the difference between app.config file and XYZ.settings file?
  11. How do I set CultureInfo.CurrentCulture from an App.Config file?
  12. How to conditionally deploy an app.config based on build configuration?
  13. How to securely store a connection string in a WinForms application?
  14. .Net app.config in library project
  15. Choosing between MEF and MAF (System.AddIn)
  16. Fake DbContext of Entity Framework 4.1 to Test
  17. Entity Framework: table without primary key
  18. What does “exited with code 9009” mean during this build?
  19. My images are blurry! Why isn’t WPF’s SnapsToDevicePixels working?
  20. Referencing 2 different versions of log4net in the same solution
  21. Truncate Decimal number not Round Off [duplicate]
  22. Can I load a 32 bit DLL into a 64 bit process on Windows?
  23. Going fullscreen on secondary monitor
  24. Calling a webservice that uses ISO-8859-1 encoding from WCF
  25. “Type not expected”, using DataContractSerializer – but it’s just a simple class, no funny stuff?
  26. Force an application to run under specific .NET runtime version?
  27. Binding in a WPF data grid text column
  28. MetadataType problem
  29. Where is the “Create Unit Tests” selection?
  30. Visual Studio popup: “the operation could not be completed”

Leave a Comment