C# 读取和设置app.config里的connectionstring
来源:互联网 发布:面试时如何谈薪资知乎 编辑:程序博客网 时间:2024/05/17 01:38
//第一种获取连接字符串的方法
Properties.Settings connset = Properties.Settings.Default;
constr = connset.ConnectionString;
//第二种获取连接字符串的方法
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["ConnectionString"];
string str = settings.ConnectionString;
//第三种获取连接字符串的方法
XmlDocument doc = new XmlDocument();
doc.Load("..//..//App.config");
XmlNode root = doc.SelectSingleNode("configuration");
XmlNode node = root.SelectSingleNode("connectionStrings/add[@name=’ConnectionString’]");
XmlElement el = node as XmlElement;
string str = el.GetAttribute("connectionString");
//在程序中设置连接字符串
connset.ConnectionString = "Data Source=orcl;Persist Security Info=True;User ID=xhfoc;Password=foc;Unicode=True";
connset.Save();
使用这种方法要修改Properties命名空间下的Settings.settings.cs文件,添加下面的代码:
[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;
}
}
//修改配置文件的方法
XmlDocument doc = new XmlDocument();
doc.Load("..//..//App.config");
XmlNode root = doc.SelectSingleNode("configuration");
XmlNode node = root.SelectSingleNode("connectionStrings/add[@name=’ConnectionString’]");
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");
Properties.Settings connset = Properties.Settings.Default;
constr = connset.ConnectionString;
//第二种获取连接字符串的方法
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["ConnectionString"];
string str = settings.ConnectionString;
//第三种获取连接字符串的方法
XmlDocument doc = new XmlDocument();
doc.Load("..//..//App.config");
XmlNode root = doc.SelectSingleNode("configuration");
XmlNode node = root.SelectSingleNode("connectionStrings/add[@name=’ConnectionString’]");
XmlElement el = node as XmlElement;
string str = el.GetAttribute("connectionString");
//在程序中设置连接字符串
connset.ConnectionString = "Data Source=orcl;Persist Security Info=True;User ID=xhfoc;Password=foc;Unicode=True";
connset.Save();
使用这种方法要修改Properties命名空间下的Settings.settings.cs文件,添加下面的代码:
[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;
}
}
//修改配置文件的方法
XmlDocument doc = new XmlDocument();
doc.Load("..//..//App.config");
XmlNode root = doc.SelectSingleNode("configuration");
XmlNode node = root.SelectSingleNode("connectionStrings/add[@name=’ConnectionString’]");
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");
0 0
- C# 读取和设置app.config里的connectionstring
- C# 读取和设置app.config里的connectionstring
- 在web.config里设置sqldatasource的connectionstring
- 关于 web.config 里自定义节点的设置和读取
- c#读取app.config
- C# app.config 读取
- c#读取配置文件 程序的App.config
- 读取Web.config中connectionString
- 如何从web.config里获取connectionString的值
- C#读取app.config文件
- C#读取配置(App.config)
- 读取webconfig里面的appSetting和connectionString
- 读取webconfig里面的appSetting和connectionString
- app.config的读取
- C#中读取和更改APP.config配置文件
- c#读取到web.config里的数据库连接字符串
- 关于C#和ASP.NET中对App.config和Web.config文件里的[appSettings]和[connectionStrings]节点进行新增、修改、删除和读取相关的操作
- 关于C#和ASP.NET中对App.config和Web.config文件里的[appSettings]和[connectionStrings]节点进行新增、修改、删除和读取相关的操作
- Bullet(Cocos2dx)之使用cocos2dx测试PhysicsWorld3D
- POJ 1984 Navigation Nightmare
- 我们的世界
- RSA算法
- C# 读取和设置app.config里的connectionstring
- eclipse工程获取工程/文件目录
- iOS中AutoLayout相关方法及流程
- 初次写作--JBoss 5 启动参数
- Bullet(Cocos2dx)之增加调试绘制PhysicsDraw3D
- java内部类的作用分析
- python encode和decode函数说明
- 四、表达式
- Axure中使用图标字体【FontAwesome】