You can check this article HOW TO: SQL & C# to learn how to call a stored procedure in a MS SQL database from a C# application as well as a Java application.
You will learn how to pass parameters to the stored procedures as well as read Out parameters returned by the sp.
Also, you will learn to how pass parameterized SQL queries from the application and read data returned by the queries.