Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Odbc Provider

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();                 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();             }          }     }