Configuration ASP.Net Tutorial

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


    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            
            ConnectionStringSettings conn = 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";
            Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/YourRoot");
            config.ConnectionStrings.ConnectionStrings.Add(conn);
            config.Save();
        }
    }



    Untitled Page