Good morning all,

I'm pretty new to VB.Net. Trying to get my head round using stored procedures to manipulate data in a database at the moment. I have managed to use a stored procedure (via my windows form) to insert data into a database but I am struggling to retreive data from my database.

I have a simple stored procedure as follows:

Code:
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
I then have then have the following code in my button_click event handler, the aim is to display the data recrieved in 3 textboxes. I don't get any error messages but I don't get the data either:

Code:
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
Any help would be greatly appreciated.

Regards,

Bern