You don't normally reorder (sort) a DataTable - and that's what your example shows,
Grouping
is a different and more complex operation - instead to reorder the view of that data as part of your presentation layer, or order the data before it arrives at the DataTable but using ORDER BY as part of your original SQL query. Assuming this is WinForms, look at the
DataGridView.Sort Method (DataGridViewColumn, ListSortDirection) (System.Windows.Forms)[
^] or investigate the
DataView Class (System.Data)[
^] which gives you a logt better control over the presentation.