方法一:
//1 在web.config的conafiguration裡面添加
<configuration>
<appSettings>
<add key="SqlConString" value="server=diablota;database=dbmessage;uid=sa;pwd="/>
</appSettings>
<connectionStrings/>
//2 建立類庫Data.cs裡面的SqlConString靜态私有屬性讀取配置檔案
using System.Configuration;
public class Data
{
private Data()
{
}
public static string SqlConString
{
get { return ConfigurationManager.AppSettings["SqlConString"]; }
}
}
//3 執行個體化的時候調用,靜态方法直接調用
SqlConnection sqlcon = new SqlConnection(Data.SqlConString)
方法二:
//1 在web.config中添加配置資訊
<configuration>
<connectionStrings>
<add name="conStr" connectionString="server=localhost;database=master;uid=sa;pwd="/>
</connectionStrings>
</configuration>
//2 添加引用
//引用程式集添加引用->選.Net下的->System.configuration
//導入命名空間System.Configuration
//3 擷取連接配接字元串
public static string GetConStr()
{
//讀取配置檔案的字元串
ConnectionStringSetting setting = ConfigurationManager.ConnectionStrings["conStr"]
//或者
ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
}