This is an old revision of the document!
The following is a very simple C# program that shows a basic connection to an Omnidex Environment and simple query processing.
===== C# Sample Code ===== <code Csharp> 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 = @"[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>
See also: