Overview | ODBC Datasources | Sample C# .NET Console Program | Sample C# .NET Windows Program

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Odbc;
 
namespace OdxODBCSample
{
  class OdxODBCSample
  {
    static void Main(string[] args)
    {
      Console.WriteLine("Omnidex Sample C# Program");
 
      string connString = 
             @"DRIVER={Omnidex};CONNECTIONSTRING=[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();
        // Execute the SQL statement
        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}\t{1}",
              reader.GetString(0),
              reader.GetString(1)
          );
        }
      } // try
      catch (Exception e)
      {
        Console.WriteLine("Sql Error: " + e);
      }
      finally
      {
        try
        {
          if (reader != null)
            reader.Close();
          if (conn != null)
            conn.Close();
        }
        catch (Exception e)
        {
          Console.WriteLine("Close Error: " + e);
        }
      }
    }
  }
}

Prev | Next

See also: