C# KONEKSI MYSQL QUERY TO DATATABLE (ADAPTER) SAMPLE CODE

public static DataTable QueryToDataTable(string Query, MySqlConnection connection)
        {
            DataTable dt = new DataTable();
            try
            {
                connection.Open();
                MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter();
                MySqlCommand cmd = new MySqlCommand(Query, connection);
                DataSet dataSet = new DataSet();
                mySqlDataAdapter.SelectCommand = cmd;
                mySqlDataAdapter.Fill(dataSet);
                dt = dataSet.Tables[0];
                connection.Close();
            }
            catch (Exception Ex)
            {
                _Msg.MessageShow_Err(Ex.Message);
            }
            return dt;
        }

public static DataTable QueryToDataTable(string Query, MySqlConnection connection) { DataTable dt = new DataTable(); try { connection.Open(); MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(); MySqlCommand cmd = new MySqlCommand(Query, connection); DataSet dataSet = new DataSet(); mySqlDataAdapter.SelectCommand = cmd; mySqlDataAdapter.Fill(dataSet); dt = dataSet.Tables[0]; connection.Close(); } catch (Exception Ex) { _Msg.MessageShow_Err(Ex.Message); } return dt; }