exceptionhandling

Question

Hi every one,
 
  can any one please tell me the sol?
 
i have one sp in sql server which is able to throw the exception when the exception is occure. now i want to catch that exception from c#.net code and i want to print that exception on the screen? how can we handle the sql server exceptions from c# code. plz give me the code with db.