Example #1
0
        public static void Test_Config_File()
        {
            // use the demo to use App.config file to get connstr and customized variable value
            string connectionString = ConfigurationManager.ConnectionStrings["SQL_Connection"].ConnectionString;

            Console.WriteLine("C4_Listing29_30, ConnStr is:{0}", connectionString);

            string Setting_Value = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).AppSettings.Settings["Setting1"].Value.ToString();

            Console.WriteLine("C4_Listing29_30, Setting1 is:{0}", Setting_Value);
            C4_Listing27.Test_SqlConnection(connectionString);
        }
Example #2
0
        public static void Test_SqlConnStrBuilder()
        {
            var sqlConnectionStringBuilder = new SqlConnectionStringBuilder();

            sqlConnectionStringBuilder.DataSource         = @"HUICHEN";
            sqlConnectionStringBuilder.InitialCatalog     = "Hui";
            sqlConnectionStringBuilder.IntegratedSecurity = true;

            string connectionString = sqlConnectionStringBuilder.ToString();

            Console.WriteLine("C4_Listing28, ConnStr is:{0}", connectionString);

            C4_Listing27.Test_SqlConnection(connectionString);
        }