c# - Can't update connection string in App.config for dataset -


to put application in production need create configuration windows modify connection parameters database.

i'm using dataset tableadapters etc... , have connection string make link database.

first, tried change update in properties.settings.default.myconnectionstring readonly. edit settings.designer.cs :

        [global::system.configuration.applicationscopedsettingattribute()]         [global::system.diagnostics.debuggernonusercodeattribute()]         [global::system.configuration.specialsettingattribute(global::system.configuration.specialsetting.connectionstring)]         [global::system.configuration.defaultsettingvalueattribute("data source=193.0.0.239\\sap;initial catalog=recouvrement;user id=sa;password=mypassword")]         public string recouvrementconnectionstringwork {             {                 return ((string)(this["recouvrementconnectionstringwork"]));             }              set {                 this["recouvrementconnectionstringwork"] = value; //adding             }         } 

and update connection string :

properties.settings.default.recouvrementconnectionstringwork = champschaineconnexion.text; properties.settings.default.save(); 

but when restart app, loose modifications.

secondly, tried modify app.config not work :

var settings = system.configuration.configurationmanager.connectionstrings[1]; var fi = typeof(configurationelement).getfield("_breadonly",bindingflags.instance|bindingflags.nonpublic); fi.setvalue(settings, false); settings.connectionstring = champschaineconnexion.text; 

if got idea,

thank in advance,

thomas


Comments

Popular posts from this blog

inversion of control - Autofac named registration constructor injection -

verilog - Systemverilog dynamic casting issues -

ios - Change Storyboard View using Seague -