Regarding Sql error code

Question

I have a small question in my mind.

Suppose I make a big stored procedure in sql server and call this sp from c# application using ado.net.
if sp returns any error or exception now i want to get the actual error with error code in application end.

Please suggest how to do ??

Thanks in advance.