Progress Monitor for IdealProgrammer.com

Take Swift, Intelligent, Massive, Planned, Loving, Effective (S.I.M.P.L.E.) Action to Transform Self into Ideal

Skip Repetitive Navigational Links

Home

News

Presenters

Contact

Please login

VB.NET ASP.NET ConfigurationManager ConnectionString Source Code Example

Description: Illustrates using Configuration Manager to retrieve connection string from web.config file for VB.NET ASP.NET. The configuration manager can be used to do many things with regard to configuration, but this example just illustrates retrieving the connection string.

Example Webform Code:

 
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ConfigurationMgrConnectionString.aspx.vb" Inherits="Configuration_ConfigurationMgrConnectionString" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Example Code Behind:

Imports System
Imports System.Data
Imports System.Data.SqlClient
Partial Class Configuration_ConfigurationMgrConnectionString
    Inherits System.Web.UI.Page
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("Northwind_ConnectionString").ConnectionString)
 
        ' Create the command object
        Dim str As String = "SELECT EmployeeID, FirstName, LastName FROM Employees"
        Dim cmd As New SqlCommand(str, con)
 
 
        Dim da As New SqlDataAdapter(cmd)
 
        Dim ds As New DataSet()
 
        da.Fill(ds, "Employees")
        GridView1.DataSource = ds
        GridView1.DataBind()
 
    End Sub
End Class

Example Connection String:

<connectionStrings>
    <add name="Northwind_ConnectionString"
      connectionString="Server=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI" />
  </connectionStrings>