Overview | ODBC Datasources | Sample C# Program

The following is a very simple C# program that shows a basic connection to an Omnidex Environment and simple query processing.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Odbc;
 
namespace OdxODBCSample
{
    class OdxODBCSample
    {
        static void Main(string[] args)
        {
            Console.WriteLine("C# OdxODBCSample");
            // Have to use a USER DSN
            string connString = @"[server1:7555]c:\class\simple.xml";
            string sqlselect = @"select NAME, PHONE from INDIVIDUALS";
            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("NAME\tPHONE\n");
                // Process the result set
                while(reader.Read())
                {
                    Console.WriteLine(
                        "{0} | {1}"
                        , reader["NAME"].ToString().PadLeft(10)
                        , reader["PHONE"].ToString().PadLeft(10)
                    );
                }
            } // try
            catch (Exception e)
            {
                Console.WriteLine("Error: " + e);
            }
        } // end main
    } // end class
} // end namespace

</code>

Prev

See also: