PROCEDURE STOCKÉ QUI RETOURNE DES VALEURS ? NON ET SI VOILOU ;-)

'voila la procedure stocké

ALTER PROCEDURE MAT_alim_oqp @nbr int output
AS
	select constructeur,puissance 
	from alimentation 
	where zonedestockage='' and etat ='ok'
	select @nbr=@@ROWCOUNT
RETURN 


'voila comment on recupere le @nbr

MyConnection = New SqlConnection
        MyConnection.ConnectionString = "server='';database='';user id='';" + _
        "password='';Trusted_Connection=true"
        oCommand = New SqlCommand("MAT_alim_oqp", SqlConnect)
        oCommand.CommandType = CommandType.StoredProcedure
        MyConnection.Open()

         Dim Parametre As SqlParameter
         Parametre = oCommand.Parameters.Add("@nbr", SqlDbType.Int)
         Parametre.Direction = ParameterDirection.Output
         oCommand.ExecuteNonQuery()
         Dim indice_utile = CInt(oCommand.Parameters("@nbr").Value.ToString())
'
' ici mettre la suite du code pour recuperer le reste des valeurs de la requete 
'
 MyConnection.Close()