SqlCommand获取存储过程的返回值

create proc GetUsers

@Count int out

as

select id,name from Users

set @Count = (Select COUNT(id) from Users)

go

            SqlParameter param = new SqlParameter("@Count",SqlDbType.Int,5);

            param.Direction = ParameterDirection.Output;

            cmd.Parameters.Add(param);

            cmd.CommandText = "GetUsers";

            cmd.Connection.Open();

            cmd.ExecuteNonQuery();

            object obj = cmd.Parameters["@Count"].Value;

            // get the value correct

            cmd.Connection.Close();



/* error */

            SqlDataReader dr = cmd.ExecuteReader();

            object obj = cmd.Parameters["@Count"].Value;

            // error the return value is null