I have an application that displays product usage information by year in a datagridview. This typically displays about 150k of records. I am trying to create an option to group by product (meaning sum up all the years info). I would like for the user to just select a radio button to change the grouping. I can run different SQL statments each time but thought there may be a better way, since I have the data already.
Can I create a new view on the table that includes the grouping or is there a way to run an sql statement against the datatable instead of requering the sql server?