using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace DataReaderExample
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                MySqlConnection conn = new MySqlConnection();
                conn.ConnectionString = "server=localhost;user id=mysql;database=db99155";
                conn.Open();

                MySqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = "SELECT name, funds FROM beings;";
                MySqlDataReader r = cmd.ExecuteReader();
                while (r.Read())
                {
                    Console.WriteLine("{0} has {1}", r.GetString("name"), r.GetUInt32("funds"));
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            Console.ReadKey();
        }
    }
}