I have a datatable that I have already filled up. I then assigned it to a dataset and bound it to a datagrid. This is all working perfectly.

I know how to do simple sort with a dataview. What i want to be able to do is something like a SQL statement.

I know theres a sqlclient.sqlcommand. I just don't know how to or if its even possible to use it to do a sql query on a dataview.

The whole point of this is i need to group by one of my fields in my datatable and also sort by one of them at the same time.

Any help would be appreciated.