using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Odbc;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            if (args.Length != 1 )
            {
                Console.WriteLine("usage: program connection-string");
                return;
            }

            String connStr = args[0];

            OdbcConnection DbConnection = new OdbcConnection( connStr );

            try
            {
                DbConnection.Open();
            }
            catch (OdbcException ex)
            {
                Console.WriteLine("connection to the data source '" + connStr + "' failed.");
                Console.WriteLine("The OdbcConnection returned the following message");
                Console.WriteLine(ex.Message);
                return;
            }

            Console.Write("SQL> ");
            String query = Console.ReadLine();

            OdbcCommand DbCommand = DbConnection.CreateCommand();

            DbCommand.CommandText = query;

            try
            {
                OdbcDataReader DbReader = DbCommand.ExecuteReader();

                int fCount = DbReader.FieldCount;

                Console.Write(":");
                for (int i = 0; i < fCount; i++)
                {
                    String fName = DbReader.GetName(i);
                    Console.Write(fName + ":");
                }
                Console.WriteLine();

                while (DbReader.Read())
                {
                    Console.Write(":");
                    for (int i = 0; i < fCount; i++)
                    {
                        String col = DbReader.GetString(i);
                        Console.Write(col + ":");
                    }
                    Console.WriteLine();
                }

                DbReader.Close();
            }
            catch (OdbcException ex)
            {
                Console.WriteLine("Executing the query '" + query + "' failed.");
                Console.WriteLine("The OdbcCommand returned the following message");
                Console.WriteLine(ex.Message);
                return;
            }

            DbCommand.Dispose();
            DbConnection.Close();
        }
    }
}