CLASSE MYSQL

using System;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
 
namespace MySQL
{
    public class SQL
    {
        public static bool mysql_connect(string string_connect)
        {
            try
            {
                ConnectionRessource = new MySqlConnection(string_connect);
                ConnectionRessource.Open();
                connected = true;
                return true;
            }
            catch (Exception Ex)
            {
                lastEx = Ex.Message;
                connected = false;
                return false;
            }
        }

        public static bool mysql_close()
        {
            if (connected)
            {
                try
                {
                    ConnectionRessource.Close();
                    connected = false;
                    return true;
                }
                catch (Exception Ex)
                {
                    lastEx = Ex.Message;
                    return false;
                }
            }
            else
            {
                lastEx = "Aucune connexion n'a encore été ouverte.";
                return false;
            }
        }

        public static string[][] mysql_query(string query)
        {
            try
            {
                com = new MySqlCommand(query, ConnectionRessource);
                dr = com.ExecuteReader();
                int count = 0;
                while (dr.Read())
                {
                    count++;
                }

                string[][] request = new string[count + 1][];
                request[0] = new string[dr.FieldCount];
                request[0][0] = count.ToString();
                dr.Close();

                com = new MySqlCommand(query, ConnectionRessource);
                dr = com.ExecuteReader();
                int j = 1;
                while (dr.Read())
                {
                    request[j] = new string[dr.FieldCount];
                    for (int i = 0; i < dr.FieldCount; i++)
                    {
                        string tmp = dr.GetString(i);
                        request[j][i] = tmp;
                    }
                    j++;
                }
                dr.Close();
                return request;
            }
            catch(Exception)
            {
                string[][] request = new string[1][];
                return request;
            }
        }

        public static int mysql_num_rows(string[][] request)
        {
            return int.Parse(request[0][0]);
        }

        public static string mysql_error()
        {
            if (connected)
            {
                if (lastEx != "")
                {
                    return lastEx;
                }
                else
                {
                    return "Il n'y a encore y aucune erreur";
                }
            }
            else
            {
                return "Erreur : Aucune connection SQL n'a encore été établie";
            }
        }

        private static bool connected = false;
        private static string lastEx = "";
        private static MySqlCommand com;
        private static MySqlDataReader dr;
        private static MySqlConnection ConnectionRessource;
    }
}