Sample Codes

MySQL Test

using System;
using System.Data;
using MySql.Data.MySqlClient;

namespace MySQL_test
{
    class Program
    {
        static void Main(string[] args)
        {
            string connstring = @"server=example.com;userid=example_user;password=example_password;database=example_database";

            MySqlConnection conn = null;
            
            try
            {
                conn = new MySqlConnection(connstring);
                conn.Open();

                string query = "SELECT * FROM table_name;";
                MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "table_name");
                DataTable dt = ds.Tables["table_name"];

                foreach (DataRow row in dt.Rows)
                {
                    foreach (DataColumn col in dt.Columns)
                    {
                        Console.Write(row[col] + "\t");
                    }

                    Console.Write("\n");                  
                }           
            }
            catch (Exception e)
            {
                Console.WriteLine("Error: {0}", e.ToString());
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }
    }
}

Console App 的多重參數

• GitHub - jpdillingham/Utility.CommandLine.Arguments

Program.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using Utility.CommandLine;

namespace Console_RabbitMQ
{
    class Program
    {
        [Argument('n', "hostname", "Host Names or IPs")]
        private static string _hostName { get; set; }

        [Argument('P', "Port", "Server Port")]
        private static int _port { get; set; }

        [Argument('u', "username", "Username")]
        private static string _userName { get; set; }

        [Argument('p', "password", "Password")]
        private static string _passWord { get; set; }

        [Argument('v', "virtualhost", "Virtualhost")]
        private static string _virtualHost { get; set; }

        [Argument('c', "queueCNT", "Queue Counts.")]
        public static int _queueCNT { get; set; }

        [Argument('q', "queueName", "Queue Name.")]
        public static string _queueName { get; set; }

        [Argument('t', "queueType", "Queue Type.")]
        public static string _queueType { get; set; }

        [Argument('m', "mqType", "MQ Type.")]
        public static string _rabbitMQType { get; set; }

        [Argument('h', "help", "Show the help.")]
        public static bool Help { get; set; }
      
      static void Main(string[] args)
        {
            Arguments.Populate();
            if (Help)
            {
                ShowHelp();

                // It guarantees that you will not proceed because you asked to show help.
                return;
            }
            Console.WriteLine("==================================");
            Console.WriteLine("Hostname: " + _hostName);
            Console.WriteLine("Port: " + _port);
            Console.WriteLine("Username: " + _userName);
            Console.WriteLine("Password: " + _passWord);
            Console.WriteLine("Virtualhost: " + _virtualHost);
            Console.WriteLine("QueueCNT: " + _queueCNT);
            Console.WriteLine("Queuename: " + _queueName);
            Console.WriteLine("Queuetype: " + _queueType);
            Console.WriteLine("RabbitMQType: " + _rabbitMQType);
            Console.WriteLine("==================================");

        private static void ShowHelp()
        {
            var helpAttributes = Arguments.GetArgumentInfo(typeof(Program));

            Console.WriteLine("Short\tLong\tFunction");
            Console.WriteLine("-----\t------\t--------");

            foreach (var item in helpAttributes)
            {
                var result = "-" + item.ShortName + "\t" + "--" + item.LongName + "\t" + item.HelpText;
                Console.WriteLine(result);
            }
        }