How to call STORED PROCEDURE with OUTPUT parmeter in mvc4

Question

Jaganathan Bantheswaran · Answer

How are you executing the SPs now in your project? Can you show us the code? In that we have to make some changes to get the output value.

anant tomar · Answer

i have data access layer business layer and in UI layer(In UI layer i have Model View Contoler)so i want to know how to use output variable in my project Model ViewController or DAL BAL Plz give me code

Jaganathan Bantheswaran · Answer

Have you tried? Do you have DataLayer? While asking questions please mention your development environment so that it will be easy to give the solution for you.

Rajesh Kumar Jha · Answer

SqlCommand cmd = new SqlCommand ( MyStoredProcedure  cn ); cmd . CommandType = CommandType . StoredProcedure ; SqlParameter parm = new SqlParameter ( @pkid  SqlDbType . Int ); parm . Value = 1 ; parm . Direction = ParameterDirection . Input ; cmd . Parameters . Add ( parm ); SqlParameter parm2 = new SqlParameter ( @ProductName  SqlDbType . VarChar ); parm2 . Size = 50 ; parm2 . Direction = ParameterDirection . Output ; // This is important! cmd . Parameters . Add ( parm2 ); cn . Open (); cmd . ExecuteNonQuery (); cn . Close (); // Print the output value Console . WriteLine ( cmd . Parameters [ @ProductName ]. Value ); Console . ReadLine (); Ref:: http://stackoverflow.com/questions/3433694/how-to-run-the-stored-procedure-that-has-output-parameter-from-c