Programatically update connectionstring using C#

jim lahey

Rate me:

4.17/5 (6 votes)

8 Nov 2011CPOL

19K

You can do the same using the configuration-specific parts of the .NET Framework to save some of the hard work:// Get the configuration file.System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);//Initialize the Connection...

You can do the same using the configuration-specific parts of the .NET Framework to save some of the hard work:

// Get the configuration file.
System.Configuration.Configuration config = 
  ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

//Initialize the Connection string builder
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder
{
   InitialCatalog = "YOUR_DATABASE",
   IntegratedSecurity = true,
   Password = "YOUR_PASSWORD"
};

// Add the connection string.
config.ConnectionStrings.ConnectionStrings["CONNECTION_NAME"].ConnectionString = 
       sqlBuilder.ConnectionString;

// Save the configuration file.
config.Save(ConfigurationSaveMode.Modified);

It'll achieve the same result provided you have the right permissions, only you don't have to treat the config file as a generic XmlDocument and parse the items to find the correct section.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

jim lahey

Software Developer (Senior)

United Kingdom

First batch file in 1987

Messed around with the Bullfrog C++ Libraries for Syndicate in 1994

Web Developer since 2000

.net Developer since 2001

MCTS: Microsoft® .NET Framework 2.0 - Web-based Client Development

MCTS: Web Applications Development with Microsoft .NET Framework 4

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Programatically update connectionstring using C#

License

Comments and Discussions