web.config 中关于数据库配置

连接字符串格式：

 

 

  <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"    providerName="System.Data.SqlClient" />
    <add name="netElectiveConnectionString" connectionString="Data Source=.\sqlexpress;Initial Catalog=netElective;Persist Security Info=True;User ID=sa;Password=198501"     providerName="System.Data.SqlClient" />
  </connectionStrings>

 

 

 

 

 

页面文件中使用Web.config配置文件中的内容：

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:netElectiveConnectionString %>" 
        SelectCommand="SELECT * FROM [Course]"></asp:SqlDataSource>