web.config的一些配置

access2003

------------------------------------------------------------------

<appSettings>
<add key="prov" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="data" value="data/test.mdb"/>
</appSettings>

        private static readonly string connectionString = System.Configuration.ConfigurationSettings.AppSettings["prov"] +
            System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["data"]) + ";";

 

sqlserver2000

------------------------------------------------------------------

  <connectionStrings>
    <add name="NorthwindDataAccess" providerName="System.Data.SqlClient" connectionString="server=127.0.0.1;database=Northwind;user id=sa;password=123"/>   
  </connectionStrings>

 

        private static readonly string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindDataAccess"].ToString();