Differences

This shows you the differences between two versions of the page.

--- dev:odbc:sample [2011/01/12 21:21]
els
+++ dev:odbc:sample [2012/10/26 14:51] (current)
@@ Line 3: / Line 3: @@
 ====== Development: ODBC Interface ======
-[[dev:odbc:home|Overview]] | [[dev:odbc:datasources|ODBC Datasources]] | **[[dev:odbc:sample|Sample C# Program]]**
+[[dev:odbc:home|Overview]] | [[dev:odbc:datasources|ODBC Datasources]] | [[dev:odbc:registering|Registering the Omnidex Driver]] | **[[dev:odbc:sample|Sample C# Program]]** | [[dev:odbc:examples:php_select | Sample PHP Program]]
 ----
-===== Sample ODBC Program =====
+===== Sample C#  Program =====
 The following is a very simple C# program that shows a basic connection to an Omnidex Environment and simple query processing.
 <code csharp>
 using System;
 using System.Collections.Generic;
-using System.Linq;
 using System.Text;
 using System.Data.Odbc;
@@ Line 22: / Line 19: @@
 namespace OdxODBCSample
 {
-    class OdxODBCSample
+  class OdxODBCSample
+  {
+    static void Main(string[] args)
     {
-        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("C# OdxODBCSample");
+          Console.WriteLine("Close Error: " + e);
-            // 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>

Back to top

dev/odbc/sample.1294867282.txt.gz · Last modified: 2012/10/26 14:47 (external edit)

Sitemap Recent Changes