How to Run Time Dynamically Build ConnectionString in Asp.Net

Please visit my new Web Site WWW.Codedisplay.com

Asp.net gives developers a class to build runtime dynamically connectionstring named SqlConnectionStringBuilder. Here in this article I will show you by an example. Please have a look at the below code example which will help you to understand how one can build dynamically connectionstring with less error possibilities.

Code Example:

using System;
using System.Data;
using System.Data.SqlClient;

public partial class Connectionstringbuilder : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //Build connectionstring
            SqlConnectionStringBuilder ConnBuilder = new SqlConnectionStringBuilder();

            ConnBuilder.DataSource = @".\SQLExpress"; // Name of the Sql Server instance
            ConnBuilder.InitialCatalog = "TestDB"; // Database Name
            ConnBuilder.UserID = "sa";
            ConnBuilder.Password = "your password";
            ConnBuilder.ConnectTimeout = 0;
            ConnBuilder.IntegratedSecurity = false;


            //How to use
            DataTable dt;
            String SQL = "SELECT Name,Description,Size,Color From Product  Order BY Name";
            using (SqlConnection Conn = new SqlConnection(ConnBuilder.ConnectionString))
            {
                using (SqlCommand comm = new SqlCommand(SQL, Conn))
                 {
                     Conn.Open();
                     using (SqlDataAdapter da = new SqlDataAdapter(comm))
                     {
                         dt = new DataTable("tbl");
                         da.Fill(dt);
                     }
                 }            
            }
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }
}

Hope now you can dynamically build your connection string if needed.