mysql-VS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using MySql.Data;
using System.Data;
using MySql.Data.MySqlClient;
namespace Proftaak_Controller
{
    class data
    {
        public static MySqlConnection con = new MySqlConnection(@"Server=localhost; Database=DATBASENAAM; Uid=; Pwd=;");
        public static MySqlCommand cmd;
        public static MySqlDataReader reader;
        public void ConsoleAllUsers()
        {
            con.Close();
            con.Open();
            cmd = new MySqlCommand("SELECT * FROM Users", con);
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                foreach (Object ob in reader)
                {
                    Console.WriteLine("id = " + reader[0]);
                    Console.WriteLine("Naam = " + reader[1]);
                }
            }
            con.Close();
        }

        public User getUser(string _kaartID)
        {
            User scannedUser = null;
            con.Close();
            con.Open();
            cmd = new MySqlCommand("SELECT * FROM Users WHERE Kaard_ID = @kaartID", con);
            cmd.Parameters.AddWithValue("@kaartID", _kaartID);
            MySqlDataAdapter adp = new MySqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            if(dt.Rows.Count != 1)
            {
                //error
                return scannedUser = new User();
            }
            Console.WriteLine(dt.Rows[0]["Naam"].ToString());
            scannedUser = new User(
                    dt.Rows[0]["Naam"].ToString(),
                    dt.Rows[0]["lastname"].ToString(),
                    Convert.ToDateTime(dt.Rows[0]["leeftijd"]),
                    Convert.ToDateTime(dt.Rows[0]["Kaart_Gemaakt"]),
                    Convert.ToDateTime(dt.Rows[0]["Laatst_Gecheckt"]),
                    Convert.ToInt32(dt.Rows[0]["id"]),
                    Convert.ToDouble(dt.Rows[0]["Money"]),
                    dt.Rows[0]["Kaard_ID"].ToString(),
                    Convert.ToBoolean(dt.Rows[0]["Abonnement"]),
                    Convert.ToBoolean(dt.Rows[0]["Geparkeerd"]));

            return scannedUser;




        }
    }
}