CREATE procedure GetA_ActionID
(@pActionName varchar( 24 ),
 @pActionID int = 0  output
)
as 
 select top  1  @pActionID=ActionID from actions where ActionName LIKE '%'+ @pActionName+'%'
 if @@rowcount= 1 
    return  0 
 else
   return - 1 
GO

string s=ConfigurationSettings.AppSettings[ "appConnString" ];
			System.Data.SqlClient.SqlConnection Conn=new SqlConnection(ConfigurationSettings.AppSettings[ "appConnString" ]);
			Conn.Open();			
			SqlCommand cmd= Conn.CreateCommand();

			cmd.Connection=Conn;
			cmd.CommandText= "GetA_ActionID" ;
			cmd.CommandType=CommandType.StoredProcedure;

			cmd.Parameters.Add( "@RetVal" ,SqlDbType.Int);
			cmd.Parameters.Add( "@pActionName" ,SqlDbType.VarChar, 24 );
			cmd.Parameters.Add( "@pActionID" ,SqlDbType.Int);

			
			cmd.Parameters[ "@pActionName" ].Value=textBox1.Text;			

			cmd.Parameters[ "@RetVal" ].Direction=ParameterDirection.ReturnValue;
			cmd.Parameters[ "@pActionName" ].Direction=ParameterDirection.Input;
			cmd.Parameters[ "@pActionID" ].Direction=ParameterDirection.Output;

            cmd.ExecuteNonQuery();
			Console.WriteLine( "--------------");
 
			Console.WriteLine (cmd.Parameters["@pActionName "].Value);
			Console.WriteLine (cmd.Parameters[" @pActionID "].Value.ToString());			
			Console.WriteLine (cmd.Parameters[" @RetVal "].Value.ToString());			
			Console.WriteLine("  --------------");
 
			//Console.WriteLine (cmd.Parameters[ 2 ].Value);
			Conn.Close();

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.