ASP.NET ConnectionString Web.config 使用方法

ASP.NET ConnectionString Web.config 使用方法

Web.config

   <configuration>

      <connectionStrings>

         <add name="ApplicationServices"
         connectionString="Data Source=VECTUS\EXPRESS; Initial Catalog=Soccer; Integrated Security=SSPI"
         providerName="System.Data.SqlClient" />

         <add name="ConnectionString2"
         connectionString="data Source=VECTUS\EXPRESS; database=Soccer; user id=sa; password=x1234567"
         providerName="System.Data.SqlClient" />

      </connectionStrings>

   </configuration>

WebForm1.aspx.cs

using System.Configuration;

SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString1"].ToString().Trim();