I have searched numerous places, and can find no lead on this.
Let us assume I have a DataSet named "Students" and a Datatable within this called "Results"
The Columns I have are Year, John, Grant, George, ie. for each year John, Grant and George will have a result, as set out below, with Year as the primary key?
Year John Grant George
1992 78 74 61
1991 91 82 63
1990 85 67 69
My question is, how do I then reference a particular cell to use my VB
Code, say John's score in 1991 (which is 91) as a Variable say called Final Score?
i.e. FinalScore = John's Score in 1991