ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. Building connection strings using ConnectionStringBuilder (VB)
<%@ Page Language="VB" %>


    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim builder As New System.Data.SqlClient.SqlConnectionStringBuilder()
        builder.DataSource = "localhost"
        builder.InitialCatalog = "Northwind1"
        builder.UserID = "sa"
        builder.Password = "password"
        builder.PersistSecurityInfo = True
        Dim config as Configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/YourRoot")
        config.ConnectionStrings.ConnectionStrings("AppConnectionString1").ConnectionString = builder.ConnectionString
        config.Save()
    End Sub



    Untitled Page