动态改变配置文件中数据库连接字符串代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】动态改变配置文件中数据库连接字符串
作者:Dezai.CN / 发布于2011/7/8/ 609
<div><span style="color: rgb(0,0,255)">#region</span><span style="color: rgb(0,0,0)"> "动态改变配置文件中数据库连接字符串"</span><span style="color: rgb(0,0,0)">
 </span><span style="color: rgb(128,128,128)">///</span><span style="color: rgb(0,128,0)"> </span><span style="color: rgb(128,128,128)"><summary></span><span style="color: rgb(0,128,0)">
 </span><span style="color: rgb(128,128,128)">///</span><span style="color: rgb(0,128,0)"> 动态改变数据库连接字符串
 </span><span style="color: rgb(128,128,128)">///</span><span style="color: rgb(0,128,0)"> </span><span style="color: rgb(128,128,128)"></summary></span><span style="color: rgb(0,128,0)">
 </span><span style="color: rgb(128,128,128)">///</span><span style="color: rgb(0,128,0)"> </span><span style="color: rgb(128,128,128)"><param name="ConnnectionString"></span><span style="color: rgb(0,128,0)">连接字符串</span><span style="color: rgb(128,128,128)"></param></span><span style="color: rgb(0,128,0)">
 </span><span style="color: rgb(128,128,128)">///</span><span style="color: rgb(0,128,0)"> </span><span style="color: rgb(128,128,128)"><param name="strKey"></span><span style="color: rgb(0,128,0)">关键值</span><span style="color: rgb(128,128,128)"></param></span><span style="color: rgb(128,128,128)">
</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">public</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">static</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">void</span><span style="color: rgb(0,0,0)"> SaveConfig(</span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> ConnnectionString, </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> strKey)
 {

 XmlDocument doc </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">new</span><span style="color: rgb(0,0,0)"> XmlDocument();

 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">获得配置文件的全路径</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">string</span><span style="color: rgb(0,0,0)"> strFileName </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> AppDomain.CurrentDomain.SetupInformation.ConfigurationFile;
 doc.Load(strFileName);
 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">找出名称为"add"的所有元素</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> XmlNodeList nodes </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> doc.GetElementsByTagName(</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">add</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">);
 </span><span style="color: rgb(0,0,255)">for</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)"> i </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,128)">0</span><span style="color: rgb(0,0,0)">; i </span><span style="color: rgb(0,0,0)"><</span><span style="color: rgb(0,0,0)"> nodes.Count; i</span><span style="color: rgb(0,0,0)">++</span><span style="color: rgb(0,0,0)">)
 {
 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">获的将当前元素的KEY属性</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> XmlAttribute att </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> nodes[i].Attributes[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">key</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">];
 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">根据元素的第一个属性来判读当前的元素是不是目标元素</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">if</span><span style="color: rgb(0,0,0)"> (att.Value </span><span style="color: rgb(0,0,0)">==</span><span style="color: rgb(0,0,0)"> strKey)
 {
 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">对目标元素中的第二个属性赋值</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> att </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> nodes[i].Attributes[</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(128,0,0)">value</span><span style="color: rgb(128,0,0)">"</span><span style="color: rgb(0,0,0)">];
 att.Value </span><span style="color: rgb(0,0,0)">=</span><span style="color: rgb(0,0,0)"> ConnnectionString;
 </span><span style="color: rgb(0,0,255)">break</span><span style="color: rgb(0,0,0)">;
 }

 }
 </span><span style="color: rgb(0,128,0)">//</span><span style="color: rgb(0,128,0)">保存修改</span><span style="color: rgb(0,128,0)">
</span><span style="color: rgb(0,0,0)"> doc.Save(strFileName);
 }
 </span><span style="color: rgb(0,0,255)">#endregion</span></div>
试试其它关键字
　数据库连接　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)