ASP And SQL 2005 Passing And Returning Parameters Doesn't Work...help!!!!!

Ok, I'm a long time reader of this forum and just about everytime I come here looking for an answer its allready been posted and answered. But I can't seem to find this one anywhere. Sorry if its allready been posted...Just point me in the right direction.

Ok, Ive been coding in VB2005 for a while but i'm new to SQL stored procedures. This is prolly going to sound stupid but I don't know where to start. Heres what I need to do.

I have a stored procedure that requires a parameter. I can pass that parameter to the stored procedure and execute it just fine. But I need the result thats returned when the stored procedure is executed. I can't seem to find anyway to return the Result back to me. DataReaders keep blowing up and I have no Idea Why????? Here is how i'm passing the param to the stored proc.

I'm running MS SQL BTW.


Dim myConnection As New SqlClient.SqlConnection("yadayada;Database=BlaBlaBla;Trusted_Connection=True;")

Dim cmd As New SqlClient.SqlCommand("NameOfStoredProc")

cmd.Connection = myConnection

cmd.CommandType = CommandType.StoredProcedure

Dim sqlParam As SqlClient.SqlParameter

sqlParam = cmd.Parameters.Add("Variable", SqlDbType.VarChar, 22)

sqlParam.Value = Address 'declared higher up.....its just an int

myConnection.Open()

cmd.ExecuteNonQuery()

myConnection.Close()



Thats all great, but I need to read back the results the stored proc returns. If I execute this in server management studio, it returns a result. But nothing I try in my asp page works. Any help would be Great. Code samples are good too.