Getting max value of a column in a datatable?

[Archaven]

Hi. I would like to know how do i obtain the maximum value of all the records in a datatable of a particular column?

For example:

Dim da As New SqlDataAdapter 
Dim dtStudents As New DataTable 

da.SelectCommand = New SqlCommand("SELECT StudentID, Name FROM Students", myConnection) 
da.Fill(dtStudents)

So now i have all my students record in the dtStudents datatable. How do i determine the maximum value of the StudentID?

Thanks in advance,
Archaven

[Lunatic3]

If you need to get it after you fill your dataset you may fetch the data orderd by StudentID descending, then read the value of first row. Also you may select the maximum from database. "Select Max(StudentID), ..."

[Archaven]

Thanks lunatic. However, i've found a better way!. Thought of sharing with everyone.

Dim da As New SqlDataAdapter
Dim dt As New DataTable
Dim objValue As Object

da.SelectCommand = New SqlCommand("SELECT StudentID, Name FROM Students", myConnection)
da.Fill(dt)
objValue = dt.Compute("Max(ID)", "")

Cheers,
Archaven

[Lunatic3]

Thats good, but it is in the expense of one computing that can be avoided if you feel you need to sort data by StudentID, so you do all in one trip to database.