simple database question

[afterMoon]

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

[Marivic]

hi,

cmSQL = New SqlCommand("select max(id) from table",cnSQL)
Dim maxid As Integer = cmSQL.ExecuteScalar()

hope this helps.

Marivic

[afterMoon]

thanks Marivic. it worked perfectly
thanks again