< , voeg naam = " LocalSqlServer " connectionString = " data source = \\ SQLEXPRESS ; Integrated Security = SSPI ; AttachDBFilename = | DataDirectory | aspnetdb.mdf ; . Gebruiker aanleg = true " providerName = " System.Data.SqlClient " /> < br >
< add name = " MainConnStr " connectionString = " data source = \\ SQLEXPRESS ; Integrated Security = SSPI ; AttachDBFilename = | DataDirectory | main.mdf ; . Gebruiker aanleg = true " name = " LocalSqlServer " >
< add name = " LocalSqlServer " connectionString = " data source = \\ SQLEXPRESS /; Integrated Security = SSPI ; . AttachDBFilename = | DataDirectory | aspnetdb.mdf ; Gebruiker aanleg = true " providerName = " System.Data.SqlClient " >
< add name = /" MainConnStr " connectionString = " data source = \\ SQLEXPRESS ; Integrated Security = SSPI ; . AttachDBFilename = | DataDirectory | main.mdf ; Gebruiker aanleg = true " providerName = " System.Data.SqlClient " />
< /connectionStrings >
De codering kan worden aangepast aan de specifieke behoeften van uw programma 's passen indien nodig . Echter, dit is de typische formaat .
Referentie 2 de verbinding strings in C + . Typ de volgende code na de code van de eerste stap : .
Snaar connstr = ConfigurationManager.ConnectionStrings [ " MainConnStr " ] ConnectionString
;
Reference 3 de verbinding strings in Visual Basic door direct na de code van de eerste stap te typen de volgende code : .
Dim connstr
As String = ConfigurationManager.ConnectionStrings ( " MainConnStr " ) ConnectionString
Reference 4 de verbinding strings in de SqlDataSource 's ConnectionString eigendom door direct na de code van de eerste stap te typen de volgende code :
< asp : SqlDataSource ID = " SqlDataSource1 " runat = " server "
ConnectionString = " < % $ connectionStrings : MainConnStr % > "
SelectCommand = " SELECT [ au_id ] , [ au_lname ] , [ au_fname ] , [ staat ] FROM [ auteurs ] " />