ALTER PROCEDURE dbo.RBTestSP1
(@Number1 Int OUTPUT, @Number2 Int OUTPUT, @Date DateTime OUTPUT)
AS
SELECT top 1 Number1, Number2, Date from RBTest

order by Date desc

Dim myConnection As New SqlConnection(connection string goes here)
Dim myCommand As New SqlCommand("Name of stored procedure", myConnection)
        myCommand.CommandType = CommandType.StoredProcedure
        Try
            myConnection.Open()

            Dim number1Param As New SqlParameter("@Number1", SqlDbType.Int, 4)
            number1Param.Direction = ParameterDirection.Output
            myCommand.Parameters.Add(number1Param)

            Dim number2Param As New SqlParameter("@Number2", SqlDbType.Int, 4)
            number2Param.Direction = ParameterDirection.Output
            myCommand.Parameters.Add(number2Param)

            Dim dateParam As New SqlParameter("@Date", SqlDbType.DateTime, 8)
            dateParam.Direction = ParameterDirection.Output
            myCommand.Parameters.Add(dateParam)

            Dim reader As SqlDataReader = myCommand.ExecuteReader()

            number1TextBox.Text = CStr(number1Param.Value)
            number2TextBox.Text = CStr(number2Param.Value)
            dateTextBox.Text = CStr(dateParam.Value)

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        Finally
            myConnection.Close()
        End Try

ALTER PROCEDURE dbo.RBTestSP1
(@Number1 INT OUTPUT, @Number2 INT OUTPUT, @DATE DATETIME OUTPUT)
AS
SELECT top 1 Number1 INTO @number1, Number2 INTO @number2, DATE INTO @DATE FROM RBTest
 
ORDER BY DATE desc

ALTER PROCEDURE dbo.RBTestSP1
(@Number1 Int OUTPUT, @Number2 Int OUTPUT, @Date DateTime OUTPUT)
AS
SELECT top 1 @Number1 = Number1, @Number2 = Number2, @Date = Date from RBTest

order by Date desc