大家好,我是架构君,一个会写代码吟诗的架构师。今天说一说修改WPF中connectionString[通俗易懂],希望能够帮助大家进步!!!
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;
此代码由Java架构师必看网-架构君整理
SqlConnectionStringBuilder scb= new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["EFDbContext"].connectionString);
string serverIP = scb.Server;
string serverPort = scb.Port.ToString();
今天文章到此就结束了,感谢您的阅读,Java架构师必看祝您升职加薪,年年好运。