SqlDataSource读取Web.Config连接字符串

把数据库的连接字符串写在Web.Config文件中，方便Asp.net页面读取

Web.Config文件

<configuration>
    <connectionStrings>
        <add name="sqlStringData" 
                providerName="System.Data.SqlClient"
                connectionString="Data Source=DB_IP;Initial Catalog=DB_Name;User ID=xxx;Password=yyy"/>
    </connectionStrings>
... ...
</configuration>

ASP页面文件

... ...
  <asp:GridView ID="gvSQLServer" DataSourceID="sqlData" runat="server" />
  <asp:SqlDataSource ID="sqlData"
         SelectCommand="select top 10 * from tableName"
         ConnectionString="<%$ ConnectionStrings:sqlStringData %>"
         runat="server" />
 </div>
... ...