public void EditConfig(string connstr)
{
XmlDocument xml = new XmlDocument();
string strFileName = AppDomain.CurrentDomain.SetupInformation.ConfigurationFile;
xml.Load(strFileName);
XmlNode xmlNode= xml.SelectSingleNode("configuration");
XmlNode node = xmlNode.SelectSingleNode("connectionStrings/add[@name=’EFDbConnection’]");
XmlElement xe = node as XmlElement;
xe.SetAttribute("connectionString", connstr);
xml.Save("strFileName");
System.Configuration.ConfigurationManager.RefreshSection("connectionStrings");
}
从connectionString中获取server,user id,password。using MySql.Data.MySqlClient;
SqlConnectionStringBuilder scb= new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["EFDbContext"].connectionString);
string serverIP = scb.Server;
string serverPort = scb.Port.ToString();