how would i get the max value of a datbase field?
in vb6, i could've write

rs.open("select max(id) from table",cn)

how can i get this value in vb.net?

thanks in advance