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
Post a Comment