SqlConnectionStringBuilder的用法

        private static void myPub_OpenSQLConnection()
        {
            if (THappyDBHelper.mpSqlConnection == null)
            {
                THappyDBHelper.mpSqlConnection = new SqlConnection();
                RegistryKey vRegCurrentUser = Registry.CurrentUser;
                RegistryKey vRegHappyCode = vRegCurrentUser.OpenSubKey("_HappyCode", true);
                string vSqlSampleName = vRegHappyCode.GetValue("SQLSampleName", "").ToString();
                string vSqlUserCode = vRegHappyCode.GetValue("SQLUserCode", "sa").ToString();
                string vSqlPassword = vRegHappyCode.GetValue("SQLPassword", "").ToString();
                string vSqlDBName = vRegHappyCode.GetValue("SQLDBName", "HappyCode").ToString();

                bool vIsUseConnBuilder = true;
                if (vIsUseConnBuilder)
                {
                    SqlConnectionStringBuilder vBuilder1 = new SqlConnectionStringBuilder();
                    vBuilder1.DataSource = vSqlSampleName;
                    vBuilder1.IntegratedSecurity = false;
                    vBuilder1.UserID = vSqlUserCode;
                    vBuilder1.Password = vSqlPassword;
                    vBuilder1.InitialCatalog = vSqlDBName;
                    vBuilder1.MultipleActiveResultSets = true;
                    vBuilder1.Pooling = true;
                    vBuilder1.MinPoolSize = 10;
                    vBuilder1.MaxPoolSize = 20;
                    THappyDBHelper.mpSqlConnection.ConnectionString = vBuilder1.ConnectionString;
                }
                else
                {
                    string vConnectionString =
                     "Pooling=true;Min Pool Size=10;Max Pool Size=20;Data Source=" + vSqlSampleName
                     + ";Initial Catalog=" + vSqlDBName + ";Persist Security Info=false;"
                     + "User ID=" + vSqlUserCode + ";Password=" + vSqlPassword
                     + ";MultipleActiveResultSets=true";
                    THappyDBHelper.mpSqlConnection.ConnectionString = vConnectionString;
                }
                try
                {
                    THappyDBHelper.mpSqlConnection.Open();
                }
                catch (Exception vException1)
                {
                    MessageBox.Show("提示: 连接设计SQL数据库失败. 错误信息如下:" + "\r\n" + vException1.Message);
                }
            }
            else
            {
                if (THappyDBHelper.mpSqlConnection.State == ConnectionState.Closed)
                {
                    THappyDBHelper.mpSqlConnection.Open();
                    return;
                }
                if (THappyDBHelper.mpSqlConnection.State == ConnectionState.Broken)
                {
                    THappyDBHelper.mpSqlConnection.Close();
                    THappyDBHelper.mpSqlConnection.Open();
                    return;
                }
            }
        }