Utilizando connection strings para web.config no ASP.NET v2.0
20/11/2010 12:02ASP.NET v2.0 - um tipico web.config v2.0 tem a seleção de configuração <configuration>.
Ex.:
<connectionStrings> </connectionStrings> Você pode obter o valor do WEB.CONFIG utilizado codigos dentro do CS.
<remove name="SqlServer" />
<add name="SqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
<add name="ConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true"providerName="System.Data.SqlClient"/>
Por Ex.: Uma referencia.
[C#] [VB] Note that the namespace for this is System.Configuration so for a console application the full namespace is required. <asp:SqlDataSource ID="SqlDataSource1" runat="server"
string strConn = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
Dim strConn As String = ConfigurationManager.ConnectionStrings("MainConnStr").ConnectionString
Or you can reference this declaratively within the ConnectionString property of a SqlDataSource:
ConnectionString="<%$ ConnectionStrings:MainConnStr %>"
SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]" />
