Search

just show me the code

Wednesday, January 7, 2009

Asp.net Connection Strings

web.config
   21   <connectionStrings configSource="Database.config"/>



Database.config

    1 <connectionStrings>
    2   <clear/> 
    3   <add name="xxxx.xxxx.ConnectionString"
    4        connectionString="Server=xxxx;Initial Catalog=xxxx;Integrated Security=True;"
    5        providerName="System.Data.SqlClient" /> 
    6   <add name="xxxx.xxxx.Membership.ConnectionString"
    7        connectionString="Server=xxxxx;Initial Catalog=xxxx;Integrated Security=True;"
    8        providerName="System.Data.SqlClient" /> 
    9 </connectionStrings>



Database.config with user and password:
    1 <connectionStrings>
    2   <clear/>
    3
    4   <add name="xxxx.xxxx.ConnectionString"
    5        connectionString="Server=xxxx;Initial Catalog=xxxx;User=xxx;Password=xxx;"
    6        providerName="System.Data.SqlClient" /> 
    7   <add name="xxx.xxxx.Membership.ConnectionString"
    8        connectionString="Server=xxx;Initial Catalog=xxx;User=xxx;Password=xxx;"
    9        providerName="System.Data.SqlClient" />
   20 </connectionStrings>

No comments:

Post a Comment

Contributors