Skip to main content

米斯特周

如何从web.config中取得ConnectionString

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

Web.Config connectionStrings 配置部分:

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

aspx 文件:

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

代码中:

C#代码:

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

VB.NET代码

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