Connecting to MySQL from Visual C#

using System;
using System.Data;
using System.Data.Common;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;

namespace MySQLDBConnection
{
    class Program
    {
        private static ConsoleColor defaultColor = Console.ForegroundColor;
        private static ConsoleColor borderColor = ConsoleColor.DarkCyan;

        static void Main(string[] args)
        {
            MySqlConnectionStringBuilder connBuilder =
                new MySqlConnectionStringBuilder();

            connBuilder.Add("Database", "shop");
            connBuilder.Add("Data Source", "localhost");
            connBuilder.Add("User Id", "root");
            connBuilder.Add("Password", "masterkey");

            MySqlConnection connection =
                new MySqlConnection(connBuilder.ConnectionString);

            MySqlCommand cmd = connection.CreateCommand();

            connection.Open();

            InsertCommand(cmd, "MQ95 Flat Monitor", 399.00);
            QueryCommand(cmd);

            connection.Close();
        }

        public static void QueryCommand(MySqlCommand cmd)
        {
            cmd.CommandText = "SELECT * FROM article";
            cmd.CommandType = CommandType.Text;

            MySqlDataReader reader = cmd.ExecuteReader();

            Console.WriteLine("Querying data in table:");
            DrawLine();
            TableHeaders();
            DrawLine();

            while (reader.Read())
            {
                Console.ForegroundColor = borderColor;
                Console.Write("|");
                Console.ForegroundColor = defaultColor;
                Console.Write(String.Format("{0,11} ", reader.GetInt32(0)));

                Console.ForegroundColor = borderColor;
                Console.Write("| ");
                Console.ForegroundColor = defaultColor;
                Console.Write(String.Format("{0,-39}", reader.GetString(1)));

                Console.ForegroundColor = borderColor;
                Console.Write("| ");
                Console.ForegroundColor = defaultColor;
                Console.Write(String.Format("{0,13:F} ", reader.GetDouble(2)));

                Console.ForegroundColor = borderColor;
                Console.Write("| ");
                Console.ForegroundColor = defaultColor;

                Console.WriteLine();
            }
            DrawLine();

            reader.Close();
        }

        public static void InsertCommand(MySqlCommand cmd, string name, double price)
        {
            cmd.CommandText = "append_data";
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add(new MySqlParameter("param_name", name));
            cmd.Parameters.Add(new MySqlParameter("param_price", price));

            cmd.ExecuteNonQuery();
        }

        private static void TableHeaders()
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("| article_id ");
            sb.Append(String.Format("{0,-41}", "| article_name "));
            sb.Append("| article_price ");
            sb.Append("|");

            Console.ForegroundColor = borderColor;

            Console.WriteLine(sb.ToString());

            Console.ForegroundColor = defaultColor;
        }

        private static void DrawLine()
        {
            Console.ForegroundColor = borderColor;

            Console.Write("+");
            for (int i = 1; i <= 12; i++)
                Console.Write("-");

            Console.Write("+");
            for (int j = 1; j <= 40; j++)
                Console.Write("-");

            Console.Write("+");
            for (int k = 1; k <= 15; k++)
                Console.Write("-");

            Console.WriteLine("+");
            Console.ForegroundColor = defaultColor;
        }
    }
}