App.config/Web.config:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="Northwind" providerName="System.Data.SqlClient" connectionString="Data Source=.;Initial Catalog=Northwind;Integrated Security=True"/>
</connectionStrings>
<appSettings>
<add key="NorthwindConn" value="Data Source=.;Initial Catalog=Northwind;Integrated Security=True"/>
<add key="prodierName" value="System.Data.SqlClient"/>
</appSettings>
</configuration>
在Framework2.0之前,可以使用 ConfigurationSettings类来管理连接字符串,通常是把连接字符串放在Appsettings里面。在程序中主要通过ConfigurationSettings.AppSettings[" string_name"];来获取。
在Framework2.0后,我们通常使用connectionStrings来管理,我们可以使用ConfigurationManager类来管理,但是要使用这个类,要add reference: System.configutation.这样才能适用其中的ConfigurationManager类。
如:
string[] results = new string[10];
results[0] = ConfigurationManager.ConnectionStrings["Northwind"].Name;
results[1] = ConfigurationManager.ConnectionStrings["Northwind"].ProviderName;
results[2] = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
results[3] = ConfigurationManager.ConnectionStrings["Northwind"].ToString(); ;
results[4] = ConfigurationManager.AppSettings["NorthwindConn"];
results[5] = ConfigurationManager.AppSettings["prodierName"];
当然,不管使用哪种方式,都必须在程序中 加入: using System.Configuration;