Development ASP.Net

  1. Home
  2. ASP.Net
  3. Development
  4. Define database connection string in web config
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

  
    

First Example: Listing data from the Employees table


                      runat="server"
                  Gridlines="None"
                  BackColor="LightBlue"
                  CellPadding="5"
                  CellSpacing="5"
                  BorderWidth="2"
                  BorderColor="Black"
                  ToolTip="Includes only those employees who are at HQ" />
  


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

<%--


  
     
     
  
  
             value="server=(local)\NetSDK; database=Northwind; integrated security=SSPI" />
  

--%>