Summarize Dataset values

[Guest]

I have a Dataset that use created from an sql query. The dataset has about
6,000 rows. I want to create arrays or lists of information about the
dataset. For example, the dataset has a column named 'State'. I would like
to count the number of rows that are for each state and the array should only
contain the states in the 6,000 rows. I realize that I could just do another
Sql query. The select method of the DataTable appears to only filter or
select rows. How could I do this?

 

[Val Mazur \(MVP\)]

There is no such automatic grouping in a DataSets. You would need to
implement some sort of expression using your code.