C# and MySQL/Connector 5.2

mysql my = new mysql("localhost", "root", "", "database");
foreach (myrecord rec in my.ExecSelect("select * from users"))
{
    MessageBox.Show(rec["user_id"] + " - " + rec["user_name"]);
}

mysql my = new mysql("localhost", "root", "", "database");
MessageBox.Show("Create: " + my.ExecOther("create table x (y int)").ToString());
MessageBox.Show("Insert: " + my.ExecOther("insert into x values (5)").ToString());
MessageBox.Show("Insert: " + my.ExecOther("insert into x values (6)").ToString());
MessageBox.Show("Insert: " + my.ExecOther("insert into x values (7)").ToString());
MessageBox.Show("Update: " + my.ExecOther("update x set y=9 where y>5").ToString());
MessageBox.Show("Delete: " + my.ExecOther("delete from x").ToString());
//MessageBox.Show("Drop: " + my.ExecOther("drop table x").ToString());

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Collections;
using System.Windows.Forms;

namespace ConqSQL
{
    class myrecord
    {
        string[] onerow;
        string[] fields;
        int FNum;

        public myrecord(string[] newfields, string[] newrow)
        {
            onerow = newrow; fields = newfields;
            FNum = newfields.Length;
        }

        public string this[string idx_str]
        {
            get
            { 
                int idx_int=-1;
                for (int i = 0; i < FNum && idx_int == -1; i++)
                {
                    if (fields[i] == idx_str) idx_int = i;
                }
                if (idx_int != -1) return onerow[idx_int];
                return "";
            }
        }
    }

    class myresult : IEnumerable
    {
        string[] fields;
        List<myrecord> data;

        public myresult(string[] newfields)
        {
            fields = newfields;
            data = new List<myrecord>();
        }

        public myresult()
        {
            data = new List<myrecord>();
        }
        public void AddResult(string[] s)
        {
            myrecord newrec = new myrecord(fields, s);
            data.Add(newrec);
        }

        public IEnumerator GetEnumerator()
        {
            return data.GetEnumerator();
        }
    }

    class mysql
    {
        string FServer;
        string FDB;
        string FUser;
        string FPass;
        string FConnStr;
        MySqlConnection conn;

        public mysql(string server, string user, string pass, string db)
        {
            FServer = server; FUser = user; FPass = pass; FDB = db;
            FConnStr = "server = " + FServer + ";\n" +
                       "database = " + FDB + ";\n" +
                       "user id = " + FUser + ";\n" +
                       "password = " + FPass + ";\n";
            conn = new MySqlConnection(FConnStr);
            conn.Open();
        }

        public int ExecOther(string SQL)
        {
            MySqlCommand cmd = new MySqlCommand(SQL, conn);
            int num;
            MySqlDataReader reader=null;
            try
            {
                reader = cmd.ExecuteReader();
                num = reader.RecordsAffected;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                num = -1;
            }
            if (reader!=null && !reader.IsClosed) reader.Close();
            return num;
        }

        public myresult ExecSelect(string SQL)
        {
            MySqlCommand cmd = new MySqlCommand(SQL, conn);
            MySqlDataReader reader=null;
            try
            {
                reader = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {
                if (reader != null && !reader.IsClosed) reader.Close();
                MessageBox.Show(ex.Message);
                return new myresult();
            }
            string[] fields;
            myresult res=null;
            int fnum=0;
            while (reader.Read())
            {
                if (res == null)
                {
                    fnum=reader.FieldCount;
                    fields=new string[fnum];
                    for (int i=0; i<fnum; i++) fields[i]=reader.GetName(i).ToLower();
                    res = new myresult(fields);
                }
                fields = new string[fnum];
                for (int i = 0; i < fnum; i++) 
                {
                    if (reader.IsDBNull(i))
                    {
                        fields[i] = "";
                    }
                    else
                    {
                        fields[i] = reader.GetString(i);
                    }
                }
                res.AddResult(fields);
            }
            reader.Close();
            return res;
        }

        ~mysql()
        {
            conn.Close();
        }
    }
}