[thelist] VB.NET 2.0 Connection String

[Ed McCarroll]

What works for me:

- In web.config:

    <connectionStrings>
        <add name="CDCGrantsConnectionString"
providerName="System.Data.SqlClient" connectionString="Data
Source=CRLADSK16279-44\SQLEXPRESS;Initial Catalog=CDCGrants;Persist
Security Info=True;User ID=cdcgrants_user;Password=password" />
    </connectionStrings>

- In MarkUp:

                    <asp:SqlDataSource ID="CdcStaffListSqlDataSource"
runat="server" ConnectionString="<%$
ConnectionStrings:CDCGrantsConnectionString %>"
                            SelectCommand="SP_CDC_STAFF_LINK_LIST"
SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter
ControlID="ApplicationIdHiddenField" DefaultValue="-3"
Name="APPLICATION_ID"
                                PropertyName="Value" Type="Int32" />
                        </SelectParameters>
                    </asp:SqlDataSource>


- Or in VB codeBehind:

    Public Function ConnectionStringGet() As String
        Dim connectionStrings As ConnectionStringSettingsCollection
        Dim lResult As String

        connectionStrings = WebConfigurationManager.ConnectionStrings
        lResult =
connectionStrings("CDCGrantsConnectionString").ToString()
        Return lResult

    End Function


-------------------------------------------------------------------- 
Ed McCarroll                                        C:(310) 904-3651
W: (323) 890-7128                                   H:(310) 838-4330
Ed at ComSimplicity.com                    http://www.ComSimplicity.com