ODBC connection : ODBC « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. ODBC

ODBC connection

using System;
using System.Data; 
using System.Data.Odbc; 

class OdbcProvider
{
   static void Main(string[] args)
   {
      string connString = @"dsn=northwindodbc";
      string sql = @"select * from employees";

      OdbcConnection conn = null;
      OdbcDataReader reader = null;

      try {
         conn = new OdbcConnection(connString);
         conn.Open();

         OdbcCommand cmd = new OdbcCommand(sql, conn);
         reader = cmd.ExecuteReader();

         Console.WriteLine(
            "Querying database {0} with query {1}\n"
            , conn.Database
            , cmd.CommandText
            );
         Console.WriteLine("First Name\tLast Name\n");

         while(reader.Read()) {
            Console.WriteLine(
               "{0} | {1}" 
               , reader["FirstName"].ToString().PadLeft(10) 
               , reader[1].ToString().PadLeft(10)
               );
         }
      } catch (Exception e) {
         Console.WriteLine("Error: " + e);
      } finally {
         reader.Close();
         conn.Close();
      }
   }
}

           
       

Related examples in the same category