CODE EXAMPLE FOR CSHARP

c# mysql select into datatable

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