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
JP.



JP.

If it is always known you can do

Dim finalScore as Integer = Convert.ToInt32(dt.Rows(1).Item("John").ToString() )

otherwise you can do something like
Dim filter as String = "Year = 1991"
Dim d[] as DataRow = DataTable.Select(filter)
Dim finalScore = Convert.ToInt32(d[0].Item("John").ToString())

hth


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hey there,

Thanks for your response. Yes, the datatable will always be known,... so that its fine.

For the 2nd solution you gave, using the DataSet name "Students" & Datatable name "Results" am I correct in thinking that I would need to specify something like

Dim datatable as Datatable = Students.Tables("results")

earlier to ensure I am using the correct datatable?

Also, in the 1st solution what does the 1 in dt.Rows(1) represent? Is this referring to Row 1.

Cheers again. This is starting to make a lot more sense!

JP.

JP.

Yes you will need to do Students.Tables("results") to get the correct datatable.

dt.Rows(1) returns the SECOND row from the table (Rows() is a 0 based collection).

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Thanks for the help!

It was just the lead in I needed, and have got it going great now.



JP.