1
System.IO.FileInfo sFileInfo
=
new
FileInfo(szConfig);
2 System.Xml.XmlDocument XmlDoc = new System.Xml.XmlDocument();
3 XmlDoc.Load(sFileInfo.FullName);
4 foreach (System.Xml.XmlNode Node in XmlDoc[ " configuration " ][ " appSettings " ])
5 {
6 if(Node.Name == "add")
7 {
8 if(Node.Attributes.GetNamedItem("key").Value == "ConnectionString")
9 {
10 string server = "(local)";
11 string dbname = textBox1.Text.Trim();
12 string user = "sa";
13 string pwd = textBox2.Text.Trim();
14 string connStr = string.Format("Persist Security Info=False;Data Source={0};Initial Catalog={1};User ID={2};Password={3};Packet Size=4096;Pooling=true;Max Pool Size=100;Min Pool Size=1", server, dbname, user, pwd);
15 Node.Attributes.GetNamedItem("value").Value = connStr;
16 }
17 else if(Node.Attributes.GetNamedItem("key").Value == "MPJ")
18 {
19 Node.Attributes.GetNamedItem("value").Value = szMPJ;
20 }
21 else if(Node.Attributes.GetNamedItem("key").Value == "MSI")
22 {
23 Node.Attributes.GetNamedItem("value").Value = szDBS;
24 }
25 }
26 }
27 XmlDoc.Save(sFileInfo.FullName);
2 System.Xml.XmlDocument XmlDoc = new System.Xml.XmlDocument();
3 XmlDoc.Load(sFileInfo.FullName);
4 foreach (System.Xml.XmlNode Node in XmlDoc[ " configuration " ][ " appSettings " ])
5 {
6 if(Node.Name == "add")
7 {
8 if(Node.Attributes.GetNamedItem("key").Value == "ConnectionString")
9 {
10 string server = "(local)";
11 string dbname = textBox1.Text.Trim();
12 string user = "sa";
13 string pwd = textBox2.Text.Trim();
14 string connStr = string.Format("Persist Security Info=False;Data Source={0};Initial Catalog={1};User ID={2};Password={3};Packet Size=4096;Pooling=true;Max Pool Size=100;Min Pool Size=1", server, dbname, user, pwd);
15 Node.Attributes.GetNamedItem("value").Value = connStr;
16 }
17 else if(Node.Attributes.GetNamedItem("key").Value == "MPJ")
18 {
19 Node.Attributes.GetNamedItem("value").Value = szMPJ;
20 }
21 else if(Node.Attributes.GetNamedItem("key").Value == "MSI")
22 {
23 Node.Attributes.GetNamedItem("value").Value = szDBS;
24 }
25 }
26 }
27 XmlDoc.Save(sFileInfo.FullName);