C# Omnidex ODBC Simple Select

• Use a USER ODBC Datasource

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Odbc;
 
namespace OdxODBCSimpleSelect
{
    class OdxODBCSimpleSelect
    {
        static void Main(string[] args)
        {
            Console.WriteLine("C# OdxODBCSimpleSelect");
            // Have to use a USER DSN
            string connString = @"dsn=OdxSystemTest1";
            string sqlselect = @"select * from table1";
            OdbcConnection conn = null;
            OdbcDataReader reader = null;
            try
            {
                // Open Connection
                conn = new OdbcConnection(connString);
                conn.Open();
                //
                OdbcCommand cmd = new OdbcCommand(sqlselect, conn);
                reader = cmd.ExecuteReader();
                // Display output header
                Console.WriteLine("MySeq\tMyText\n");
                // Process the result set
                while(reader.Read())
                {
                    Console.WriteLine(
                        "{0} | {1}"
                        , reader["MYSEQ"].ToString().PadLeft(10)
                        , reader["MYTEXT"].ToString().PadLeft(10)
                    );
                }
            } // try
            catch (Exception e)
            {
                Console.WriteLine("Error: " + e);
            }
        } // end main
    } // end class
} // end namespace