Using SQL Server and ASP.Net, how do I open a recordset and set a variable to equal a field in that recordset. I only have notepad with me right now so it is proving difficult.

Dim NewID as Integer

Recordset = "Select MAX(ID) From myTable"

NewID = Rs.Fields("ID")

is the just of it.

Thanks