using System;

using System.Data;

​

using MySql.Data;

using MySql.Data.MySqlClient;

​

public class Tutorial2

{

    public static void Main()

    {

        string connStr = "server=localhost;user=root;database=test;port=3306;password=root;";

        MySqlConnection conn = new MySqlConnection(connStr);

        try

        {

            Console.WriteLine("Connecting to MySQL...");

            conn.Open();

​

            string sql = "SELECT Name, HeadOfState FROM Country WHERE Continent='Oceania'";

            MySqlCommand cmd = new MySqlCommand(sql, conn);

            MySqlDataReader rdr = cmd.ExecuteReader();

​

            while (rdr.Read())

            {

                Console.WriteLine(rdr[0]+" -- "+rdr[1]);

            }

            rdr.Close();

        }

        catch (Exception ex)

        {

            Console.WriteLine(ex.ToString());

        }

​

        conn.Close();

        Console.WriteLine("Done.");

    }

}

​