Differences

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

Link to this comparison view

Next revision
Previous revision
dev:odbc:sample [2011/01/12 01:04]
els created
dev:odbc:sample [2012/10/26 14:51] (current)
Line 3: Line 3:
 ====== Development:​ ODBC Interface ====== ====== Development:​ ODBC Interface ======
  
-[[dev:​odbc:​home|Overview]] | **[[dev:​odbc:​sample|ODBC Datasources]]** | [[dev:odbc:sample|Sample 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]]
 ---- ----
  
  
-===== 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.
  
-The Omnidex ODBC Driver supports the standard methods of connecting to the databases - Machine Datasources (SYSTEM and USER Datasources) and File Datasources.  The driver supports DSN-less connections as well.+<code csharp>​ 
 +using System; 
 +using System.Collections.Generic; 
 +using System.Text;​ 
 +using System.Data.Odbc;​
  
-{{page>:​dev:​odbc:​datasource_include&​nofooter&​noeditbtn}}+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);
 +        }
 +      }
 +    }
 +  }
 +}
 +</​code>​
  
 =====  ===== =====  =====
  
-**[[dev:​odbc:​home|Prev]]** | **[[dev:​odbc:​sample|Next]]**+**[[dev:​odbc:​datasources|Prev]]**
  
 ====== Additional Resources ====== ====== Additional Resources ======
Line 23: Line 81:
 See also:  See also: 
  
-{{page>:​dev:see_also:​see_also&​nofooter&​noeditbtn}}+{{page>:​dev:​see_also&​nofooter&​noeditbtn}}
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
  
 
Back to top
dev/odbc/sample.1294794277.txt.gz · Last modified: 2012/10/26 14:47 (external edit)