C#: ODBC (PgSQL2)

 

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

public class Program
{
 public static void Main(string[] args)
 {
 OdbcConnection conn = new OdbcConnection("DSN=PgSQLtest");
 conn.Open();
 OdbcCommand cmd = new OdbcCommand("SELECT * FROM table1", conn);
 OdbcDataReader reader = cmd.ExecuteReader();
 PrintData(reader);
 reader.Close();
 conn.Close();
 Console.WriteLine("End.");
 }

 public static void PrintData(OdbcDataReader reader)
 {
 while (reader.Read())
 {
 string code = reader.GetString(0);
 string name = reader.GetString(1);
 int count = reader.GetInt32(2);
 Console.WriteLine(code + ", " + name + ", " + count.ToString());
 }
 }
}