How to call STORED PROCEDURE with OUTPUT parmeter in mvc4

Question

How to call STORED PROCEDURE with OUTPUT parmeter in  mvc4

Answer 1

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.

Answer 2

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 ,View,Controller or DAL ,BAL Plz give me code 

Answer 3

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.

Answer 4

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