get data from dataset

[Palmtree]

I want to get the max column value from a table, the following is my 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?

[salvelinus]

Lots of different ways. One would be:

strID = dsTemp.Tables("teacher").rows(0).item(0)
messagebox.show(strID)

I haven't seen odbcadapter, though. Sure you don't mean oledbdataadapter? Maybe it's a reference I haven't used.

[Palmtree]

thanks for your reply.

I use mySql database, it uses odbc data provider.