Binding Stored Procedure OUTPUT Parameters To A TextBox, How?

Hi all;





How can I show the Name & Age of the selected student's ID in the appropriate TextBox(s) (txtName & txtAge)?





BTW:





My "ShowStudent" stored procedure:





ALTER PROCEDURE ShowStudent


@ID int


AS


SELECT ID, Name, Age FROM Student WHERE ID=@ID


RETURN











And this is the code for "Show" button:





' Which SP? Connection?


Dim cmdSelect As New SqlCommand("ShowStudent", con)


cmdSelect.CommandType = CommandType.StoredProcedure





'-----[ Spacifay SP parameters ]-----





'ID


cmdSelect.Parameters.Add("@ID", SqlDbType.Int, 4)


cmdSelect.Parameters("@ID").Value = CType(txtID.Text, Integer)





'Open Connection


con.Open()











'-----[ Execute the select command ]-----





cmdSelect.ExecuteReader()








'----------------------------------------





'Close connection


con.Close()





'========================================================


End Sub














So, do I have to use an OUTPUT parameter in the stored procedure? If Yes, How to get its (the parameter) value and bind it to the appropriate TextBox?





Hope my question is clear!!





Thanks in advanced!