数据库连接字符串写在配置文件中。怎么在cs文件中获取它

数据库连接字符串写在配置文件中。如何在cs文件中获取它？
我的配饰文件连接代码：

C# code

<connectionStrings>      <add name="GPD" connectionString="data source=172.16.161.*;User ID=sa;pwd=test;Initial Catalog=GPD" />    </connectionStrings>

后台cs怎么获取它？

[解决办法]
http://www.cnblogs.com/wf5360308/articles/1154962.html

1.<connectionStrings> 
<connectionStrings> 
<add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" 
providerName="System.Data.SqlClient" /> 
</connectionStrings>

[解决办法]
http://www.cnblogs.com/wf5360308/articles/1154962.html

1.<connectionStrings> 
<connectionStrings> 
<add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" 
providerName="System.Data.SqlClient" /> 
</connectionStrings>

ConfigurationManager.ConnectionStrings["connectionStringsName"].ToString(); 

[解决办法]

C# code

<configuration>    <appSettings>        <add key="conStr" value="Server=.;Database=ETer;uid=sa;pwd=sa"/>    </appSettings>    <connectionStrings/>
[解决办法]
C# code
//添加引用using System.Configuration;//获取配置文件连接字符串String connStr = ConfigurationManager.ConnectionStrings["connectionString"].ToString();
[解决办法]
//添加引用
using System.Configuration;

//获取配置文件连接字符串
String connStr = ConfigurationManager.ConnectionStrings["GPD"].ToString();


[解决办法]
配置文件中：
   </connectionStrings>
<connectionStrings>
     <add name="GPD" value="data source=172.16.161.*;User ID=sa;pwd=test;Initial Catalog=GPD" />
   </connectionStrings>

CS中
//添加引用  
using System.Configuration;  

//获取配置文件连接字符串  
String connStr = ConfigurationManager.ConnectionStrings["GPD"].ToString();  


[解决办法]
string connstr=System.Configuration.ConfigurationSettings.AppSettings["GPD"]; 

 

查看更多 下一篇