If you have several queries that get single values, why not use the even simpler: command.ExecuteScalar(). That will return a single value and you don't need to .Read() thru a reader at all. Then just assign the value to your textbox.

-Peter

Sorry to sound dumb here, but you wouldnt happen to have a code exmaple??

Dim objCmd As SqlCommand
Dim strValue As String

objCmd = New SqlCommand("SELECT field FROM table", objMyConnection)
objCmd.Connection.Open()
strValue = objCmd.ExecuteScalar()
objCmd.Connection.Close()


-Peter