Stored Proc Returning Dataset && Number Of Records Not Working

Hi





I've created a sproc in SQL2000 that returns a dataset from a temp table & the number of records it's returning as an output parameter, although I can't seem to retrieve the value it's returning in asp.net although I get the dataset ok.





This is my sproc


create procedure return_data_and_value


@return int output


as


set nocount on


...


...


select * from #Table


select @return = count(*) from #Table


drop table #Table


go





This is asp.net code





Dim nRecords as Int32


Dim cmd As SqlCommand = New SqlCommand("return_data_and_value", conn)


cmd.CommandType = CommandType.StoredProcedure





Dim prm As SqlParameter = New SqlParameter("@return", SqlDbType.Int)


prm.Direction = ParameterDirection.Output


cmd.Parameters.Add(prm)





conn.Open()





dr = cmd.ExecuteReader





nRecords = convert.int32(cmd.parameters(@return).value)





conn.close








Thanks


Lbob