ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. Automatically converts any connection string into its canonical representation
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
    protected void btnConvert_Click(object sender, EventArgs e)
    {
        SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder("Server=localhost;UID=webuser;pwd=secret;database=Northwind");
        lblResult.Text = builder.ConnectionString;
    }



    SQL Connection String Builder


    
    

            id="txtConnectionString"
        Columns="60"
        Runat="Server" />
            id="btnConvert"
        Text="Convert"
        OnClick="btnConvert_Click"
        Runat="Server" />
    
            id="lblResult"
        Runat="server" />