Define database connection string in web.config

<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

<html>
  <body>
    <h4>First Example: Listing data from the Employees table</h4>
    <asp:DataGrid id="dgNameList"
                  runat="server"
                  Gridlines="None"
                  BackColor="LightBlue"
                  CellPadding="5"
                  CellSpacing="5"
                  BorderWidth="2"
                  BorderColor="Black"
                  ToolTip="Includes only those employees who are at HQ" />
  <body>
</html>

<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
  Dim strConnection As String = ConfigurationSettings.AppSettings("yourSettingInWebConfig")
  Dim objConnection As New SqlConnection(strConnection)

  Dim strSQL As String = "SELECT FirstName, LastName, Country " & _
                         "FROM Employees;"
  Dim objCommand As New SqlCommand(strSQL, objConnection)

  objConnection.Open()

  Response.Write("ServerVersion: " & objConnection.ServerVersion & _
                 vbCRLF & "Datasource: " & objConnection.DataSource & _
                 vbCRLF & "Database: " & objConnection.Database)

  dgNameList.DataSource = objCommand.ExecuteReader()
  dgNameList.DataBind()
  objConnection.Close()
End Sub
</script>

<%--
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <system.web>
     <customErrors mode="Off" />
     <compilation debug="true"/>
  </system.web>
  <appSettings>
    <add key="yourSettingInWebConfig"
         value="server=(local)\NetSDK; database=Northwind; integrated security=SSPI" />
  </appSettings>
</configuration>

--%>

Related examples in the same category

1.	Set culture in the web.config
2.	This section sets the globalization settings of the application
3.	Get variables from global.asax
4.	Remove key from web.config
5.	web.config: default error page
6.	web.config: appSettings
7.	Indicate the error page in web.config
8.	web.config: redirect to a url for a status code
9.	web.config: custom error with default redirect and mode
10.	web.config: configure application-specific configuration settings
11.	web.config: customErrors
12.	web.config: session State
13.	web.config: Forms authentication
14.	web.config: authorization
15.	web.config: trace mode
16.	web.config: authentication mode
17.	Application-Level Trace Logging?
18.	Dynamic Debug Compilation
19.	Custom Error Messages
20.	Adding culture detection to the Web.config file
21.	Session State configuration
22.	HTTP Module configuration
23.	Storing a connection string
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

Define database connection string in web.config : web.config « Development « ASP.Net

Related examples in the same category