Possibly tricky: Sorting Dataset with group by and order by

[Cander]

Ok, we have a Dataset which contains a table full of data that was populated form multiple text files.

Now we need to take that table and in some way group it and sort it into another datatable for summary information.

Any ideas on how to achieve this?

.Select does not like Group By syntax, but it does have a sort parameter, so that will probably do fine for the order by part. But still, the group by doesnt seem possible.

[DevGrp]

Have you tried using a DataView? That might help.

[Cander]

yes. but no Grouping options are available that I can figure.

[DevGrp]

I have'nt found a way to do it from the DataSet, but I did do it using the select statement.

[Lunatic3]

http://support.microsoft.com/default...en-us%3b325685