What Property Should I Assign To My Sqlcommand ?

what property should i assign to myPuzzleCmd2 ? 

 

myConnection.Open()

 Dim myPuzzleCmd2 As New SqlCommand("GetRandomCode", myConnection)

 

myPuzzleCmd2.CommandType = CommandType.StoredProcedure

 Dim retLengthParam As New SqlParameter("@Length", SqlDbType.TinyInt, 6)

retLengthParam.Direction = ParameterDirection.Input

 

myPuzzleCmd2.Parameters.Add(retLengthParam)

 Dim retRandomCode As New SqlParameter("@RandomCode", SqlDbType.VarChar, 30)

 

retRandomCode.Direction = ParameterDirection.Output

 

myPuzzleCmd2.Parameters.Add(retRandomCode)

 

Try

 Dim reader As SqlDataReader = myPuzzleCmd2.ExecuteReader()

myPuzzleCmd.ExecuteNonQuery()Catch ex As Exception

 

myPuzzleCmd2 = Nothing

 Session.Remove("RandomCode")

 HttpContext.Current.Session("RandomCode") = myPuzzleCmd2("@RandomCode")        <  ---------       Over here

 Finally

myConnection.Close()

End Try