asp.net数据库连接字符串

在web.config这样写

<appSettings>

<add key="NWind"

value="server=(local);database=Northwind;User id=sa;Pwd=sa;"/>

</appSettings>

这样调用

 String strConnection=ConifgurationSettings.AppSettings["NWind"];

若在web.config这样写(可自动生成)

<configuration>
 <connectionStrings>
    <add name="SocutConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:/www/Data/Socut.mdb" providerName="System.Data.OleDb"/>
 </connectionStrings>
 <appSettings/>
 

这样调用

方法一：

string myConn = System.Configuration.ConfigurationManager.ConnectionStrings["SocutConnectionString"].ConnectionString;

方法二：

string myConn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SocutConnectionString"].ToString();