ADO Net Database ASP.Net Tutorial

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


    protected void Page_Load(object sender, EventArgs e)
    {
        System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
        builder.DataSource = "localhost";
        builder.InitialCatalog = "Northwind1";
        builder.UserID = "sa";
        builder.Password = "password";
        builder.PersistSecurityInfo = true;
        Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/Yourroot");
        config.ConnectionStrings.ConnectionStrings["AppConnectionString1"].ConnectionString = builder.ConnectionString;
        config.Save();
    }



    Untitled Page