Using Select Method on a DataTable in C# .Net
October 18, 2010 0 CommentsIn previous article I populated a DataTable called 'leagueTable' with data read in from a comma delimited text file and performed operations on this data to get it into the format I wanted.
The league table has the name of the team and number of wins and draws home and away ready to calculate the relative strengths of each result. For each home team I will re evaluate the rating of its opponent based on all its other away results excluding the current fixture.
For example the fixture Team A v Team B, would require re evaluating all away matches for Team B excluding the current one against Team A. To do this I need to run a query on the DataTable that holds all the result data called 'importResultsTable'.
One feature of the DataTable is that it can perform SQL queries on the data it holds in memory by ...
Subscribe