如何从web.config中取得ConnectionString

通过使用ConfigurationManager，你可以从Web.Config中取得ConnectionString。

Web.Config connectionStrings 配置部分:

1
2
3
    <connectionStrings>
    <add name="MyConnectionString" connectionString="Data Source=myDBServer;database=myDB;Integrated Security=True;" providerName="System.Data.SqlClient"/>
    </connectionStrings>

aspx 文件:

1
    <asp:SqlDataSource ID="DS" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>

代码中:

C#代码:

1
    string strConnString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

VB.NET代码

1
    Dim strConnString As String = ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString