Click here to Skip to main content
11,478,619 members (63,977 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
Hi Guys,

Hope someone can shed some light,

I need to add a whole section to my config file. This is what i need to add to my app.config file is:

<connectionStrings>
        <add name="Database" connectionString="Server=BACKSERVER;database=Fingerscan;connection timeout=30;User Id=sysdba;Password=masterkey"
            providerName="System.Data.SqlClient" />
</connectionStrings>

I need to do this at runtime. I need to add the entire connectionStrings section with tags

Is this possible?

Thanks in advance.
Posted 22-Apr-13 23:51pm
Comments
AlluvialDeposit at 23-Apr-13 4:55am
   
As the filename says, it's a config file. You really should not add data to that file at runtime. What kind of data are you trying to add?
RoelofJanster at 23-Apr-13 5:06am
   
I need to add the entire Connectionstrings section to the app.config file if it does not exist in that config file. I an doing an SDK Integration.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Got the solution

try
           {
               var cfg = ConfigurationManager.OpenExeConfiguration(Assembly.GetExecutingAssembly().Location);
               var setting = new ConnectionStringSettings();
 
               setting.ConnectionString = "Server=BACKSERVER;database=Database;connection timeout=30;User Id=sysdba;Password=masterkey";
               setting.Name = "DatabaseName";
               cfg.ConnectionStrings.ConnectionStrings.Add(setting);
               cfg.Save();
           }
           catch (Exception ex)
           {
               Console.WriteLine(ex.ToString());
           }
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 289
1 F-ES Sitecore 170
2 Frankie-C 120
3 OriginalGriff 105
4 DamithSL 95
0 Sergey Alexandrovich Kryukov 7,865
1 OriginalGriff 7,341
2 Sascha Lefèvre 3,059
3 Maciej Los 2,491
4 Richard Deeming 2,335


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 23 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100