I want to get the max column value from a table, the following is my code:
VB Code:
Dim dsTemp As DataSet = New DataSet() Dim daTemp As OdbcDataAdapter = New OdbcDataAdapter("Select Max(id) as MaxID from teacher", connTeacher) daTemp.Fill(dsTemp, "teacher")
How can I get the value of the MaxID?




Reply With Quote