Lo puedes hacer con un datareader, por ejemplo
Código ASP:
Ver originalDim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim dr As New SqlDataReader()
'declaring the objects
sub data()
myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs")
'establishing connection. you need to provide password for sql server
Try
myConnection.Open()
'opening the connection
myCommand = New SqlCommand("Select * from discounts where usuario='" & usuario & "'", myConnection)
'executing the command and assigning it to connection
dr = myCommand.ExecuteReader()
While dr.Read()
lbloro.text=dr(0).tostring()
End While
dr.Close()
myConnection.Close()
Catch e As Exception
End Try
End Sub
Prueba esto, nada mas cambia los datos de la base de datos y la instruccion select