C # multiple methods to read and set connection strings

// Method 1 for obtaining the connection string
Properties. settings connset = properties. settings. default;
Constr = connset. connectionstring;

// Method 2 for obtaining the connection string
Connectionstringsettings settings = configurationmanager. connectionstrings ["connectionstring"];
String STR = settings. connectionstring;

// Method 3 for obtaining the connection string
Xmldocument Doc = new xmldocument ();
Doc. Load ("../.. // app. config ");
Xmlnode root = Doc. selectsinglenode ("configuration ");
Xmlnode node = root. selectsinglenode ("connectionstrings/Add [@ name = 'ononstring']");
Xmlelement El = node as xmlelement;
String STR = El. getattribute ("connectionstring ");

// In Program Set the connection string
Connset. connectionstring = "Data Source = orcl; persist Security info = true; user id = xhfoc; Password = FOC; Unicode = true ";
Connset. Save ();
To use this method, modify the settings. settings. CS file in the properties namespace and add the following Code :
[Global: system. configuration. applicationscopedsettingattribute ()]
[Global: system. Diagnostics. debuggernonusercodeattribute ()]
[Global: system. configuration. specialsettingattribute (Global: system. configuration. specialsetting. connectionstring)]
[Global: system. configuration. defaultsettingvalueattribute ("Data Source = orcl; persist Security info = true; user id = xhfoc; Password = FOC; Unicode = true")]

Public String connectionstring
{
Get
{
Return (string) (This ["connectionstring"]);
}
Set
{
This ["connectionstring"] = value;
}
}

// Method for modifying the configuration file
Xmldocument Doc = new xmldocument ();
Doc. Load ("../.. // app. config ");
Xmlnode root = Doc. selectsinglenode ("configuration ");
Xmlnode node = root. selectsinglenode ("connectionstrings/Add [@ name = 'ononstring']");
Xmlelement El = node as xmlelement;
El. setattribute ("connectionstring", "Data Source = orcl; persist Security info = true; user id = xhfoc; Password = FOC; Unicode = true ");
Doc. Save ("../.. // app. config ");

 

 

Turn: http://blog.csdn.net/lishiwenblog/archive/2007/07/22/1701851.aspx