public void InsertRow(string connectionString, string insertSQL)
{
    using (OdbcConnection connection = 
               new OdbcConnection(connectionString))
    {
        // The insertSQL string contains a SQL statement that
        // inserts a new row in the source table.
        OdbcCommand command = new OdbcCommand(insertSQL, connection);

        // Open the connection and execute the insert command.
        try
        {
            connection.Open();
            command.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }

//引入命名空间
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();
      }
   }
}