fill data table with row details from mysql code example

Example: c# mysql select into datatable

MySqlCommand cmd = new MySqlCommand(query, connection);
DataTable dt = new DataTable();
dt.load(cmd.ExecuteReader());
return dt;