Storing a connection string : web.config « Development « ASP.Net






Storing a connection string

 
<configuration>
  <connectionStrings>
    <add
        name = "my"
        connectionString = "server=local;database=myDB;
        uid=WebUser;pwd=password" />
  </connectionStrings>
</configuration>


Retrieving a connection string (VB)
Public Sub Page_Load (sender As Object, e As EventArgs) 
    ...
    Dim dbConnection as New _
        SqlConnection(ConfigurationSettings.ConnectionStrings("my"))
    ...
End Sub
   
Retrieving a connection string (C#)
public void Page_Load (Object sender, EventArgs e) 
{
    ...
    SqlConnection dbConnection = new    
        SqlConnection(ConfigurationSettings.ConnectionStrings["my"]);
    ...
}
 

 








Related examples in the same category

1.Set culture in the web.config
2.Define database connection string in web.config
3.This section sets the globalization settings of the application
4.Get variables from global.asax
5.Remove key from web.config
6.web.config: default error page
7.web.config: appSettings
8.Indicate the error page in web.config
9.web.config: redirect to a url for a status code
10.web.config: custom error with default redirect and mode
11.web.config: configure application-specific configuration settings
12.web.config: customErrors
13.web.config: session State
14.web.config: Forms authentication
15.web.config: authorization
16.web.config: trace mode
17.web.config: authentication mode
18.Application-Level Trace Logging?
19.Dynamic Debug Compilation
20.Custom Error Messages
21.Adding culture detection to the Web.config file
22.Session State configuration
23.HTTP Module configuration
24.Configuring Session State with a connection string
25.specify custom provider assembly that inherits the SessionStateStoreProviderBase class
26.The compilation section
27.authentication section
28.Forms Authentication
29. configuration section settings
30.URL Authorization in the web.config file with and attributes
31.asterisk (*) represents all users and the question mark (?) represents anonymous users
32.grant or deny access to the users or groups in regard to the HTTP methods
33.File Authorization
34.Set the security for a single file
35.Locking-Down Configuration Settings
36.ASP.NET Page Configuration
37.Configuring ASP.NET Runtime Settings
38.Default format for the section
39.Custom configuration setting
40.Set httpRuntime maxRequestLength='2048'
41.compilation debug="true"
42.ConfigurationManager.AppSettings
43.Custom Configuration Sections
44.Create custom section in Web.Config