C # Call the SQL Server Stored Procedure Return Value

-- Return value using parameterdirection. returnvalue;
Create procedure DBO.
As
Declare @ I int
Select @ I = count (*) from tbd_m_modle
Return @ I
Go

-- Return value using parameterdirection. output;
Create procedure DBO.
@ I int output
As

Select @ I = count (*) from tbd_m_modle
Return @ I
Go

//
Sqlcommand cmd = new sqlcommand ("A", myconn );
Cmd. commandtype = commandtype. storedprocedure;

// Input value
// Sqlparameter a1 = new sqlparameter ("@ A", sqldbtype. varchar, 100 );
// A1.value = "AAA ";
// Cmd. Parameters. Add (A1 );

// Return Value
Sqlparameter I = new sqlparameter ("@ II", sqldbtype. Int, 4 );
I. Direction = parameterdirection. output;
// I. Direction = parameterdirection. returnvalue;
Cmd. Parameters. Add (I );

Cmd. executenonquery ();

String strreturn = I. value. tostring (); // return value -- Method 1
String A = cmd. Parameters ["@ II"]. value. tostring (); // return value -- method 2

Cmd. Connection. Close ();