need a return value from the stored procedure.

Question

I am trying to update a SQL-SERVER table using a Stored-Procedure which is called in a web-Service.
here i need a return value from the stored procedure so that i can send true or false to the user regarding the update confirmation.

I am Using C# as the language and ADO.Net architecture for connecting and manipulating SQL-Server Tables.

I am also using SQLDataConnection(System.Data.SqlClient).


Thanks in Advance