Suggest some solution on my following C# code

See more:

SQL-Server

SQL-Server-2008

Hi,

Kindly suggest solution on following problem. I have 3 SP(Stored Procedures) in code. If any of these fail, I want the error to be produced to the output. I want to know which transaction failed and what happened, before roll back.
Note: We can't do any changes in SQL server's SP, have to provide some functionality in C# code only.

Code is :

try
{
    SP1 with A output
    SP2 with B output
    SP3 with C output
}
catch (Exception ex)
{
  //exception
}

Thanks,
AVINCODE