Click here to Skip to main content
Click here to Skip to main content
Alternative Tip

Tagged as

Go to top

Programatically update connectionstring using C#

, 8 Nov 2011
Rate this:
Please Sign up or sign in to vote.
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)

Share

About the Author

jim lahey
Software Developer (Senior)
United Kingdom 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

Comments and Discussions

 
GeneralMy app.config file <code> <configuration> <configsections... PinmemberPritesh Aryan15-Nov-11 23:33 
GeneralReason for my vote of 2 This gives following error. exePath ... PinmemberMukund Thakker15-Nov-11 0:24 
GeneralSystem.Configuration.Configuration config = System.Configura... PinmemberMukund Thakker15-Nov-11 0:22 
GeneralReason for my vote of 5 excellent alternative..thanks PinmemberB Birajdar8-Nov-11 9:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

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

| Advertise | Privacy | Mobile
Web02 | 2.8.140922.1 | Last Updated 8 Nov 2011
Article Copyright 2011 by jim lahey
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid