I have a DataSet that has been returned by another method.
This DataSet returns a list of numbers, I need to loop through this data and find the largest number in the list and on what row it's on.
How do I do this? I have no idea where to start! I tried using a foreach loop, but it tells me I can't use that when working with DataSets.
In case you need it, this is my SQL string that populates the DataSet
SqlCommand dataCommand = new SqlCommand("SELECT COUNT(*) FROM game WHERE leagueyear = @cYear GROUP BY venueid", conndb);
I usually try to provide some code to show I've done something, but I really don't know where to start with this.