How to Capture StoredProcedure Errors into Application
Recently I have been working on data access layer and wondering how to capture raise errors of stored procedure. I realized we can't capture stored procedure error if dataset being used in application. In order to capture stored procedure error, application should use Data Reader instead of Data Adapter. Ref: http://support.microsoft.com/kb/811482 Thanks, -Venu.