Get stored procedure parameters by either C# or SQL?

select * from information_schema.parameters
where specific_name="your_procedure_name"

Also refer this post to know more methods
https://exploresql.com/2016/10/14/different-methods-to-get-parameter-list-of-a-stored-procedure/