require 'mscorlib'
require 'System'
require 'MySql.Data'
include System
include MySql::Data::MySqlClient
 
conStr = "server=localhost;user id=root;password=P@ssW0rd"
sqlStr = "SELECT 'Hello, Connector/NET World!' AS Message"
 
con = MySqlConnection.new(conStr)
cmd = MySqlCommand.new(sqlStr, con)
con.Open()
 
reader = cmd.ExecuteReader()
while reader.Read() do
    Console.WriteLine( reader.GetName(0) )
    Console.WriteLine( "---------------------" )
    Console.WriteLine( reader.GetValue(0) )
end
 
reader.Close()
con.Close()