Configuration ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Configuration
  4. Modifying connection string properties at runtime (VB)
<%@ Page Language="VB" %>


    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    
        If (Not Page.IsPostBack) Then
            Dim conn As New ConnectionStringSettings()
            conn.ConnectionString = _
                 "Server=localhost;User ID=sa;Password=password" & _
                 "Database=Northwind;Persist Security Info=True"
            conn.Name = "AppConnectionString2"
            conn.ProviderName = "System.Data.SqlClient"
            Dim config as Configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/YourRoot")
            config.ConnectionStrings.ConnectionStrings.Add(conn)
            config.Save()
        End If
    End Sub



    Untitled Page