using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Odbc;
using System.Data;

namespace SynergyTester
{
    class Program
    {
        static void Main(string[] args)
        {
            OdbcConnection cn = new OdbcConnection("DSN=xfODBC;");
            try
            {
                cn.Open();
                if(cn.State == System.Data.ConnectionState.Open)
                {
                    Console.WriteLine("Connection Open...");
                    DataSet ds = new DataSet();
                    OdbcDataAdapter da = new OdbcDataAdapter("SELECT TOP 10 * FROM HISHDR", cn);
                    da.Fill(ds);
                    Console.WriteLine("Getting top 10 rows...");
                    foreach(DataRow row in ds.Tables[0].Rows)
                    {
                        Console.WriteLine(
                            String.Format(
                                "Second field value is {0}",
                                new object[] { row[1].ToString() }
                            )
                        );
                    }

                    ds.Dispose();
                    da.Dispose();
                    cn.Close();
                    cn.Dispose();
                    Console.WriteLine("Test Completed...");
                }
                

            } catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
    }
}