stored procedure exception handling in asp.net

Question

Do i need to use try catch in my stored procedure to know where exactly in my procedure error has occured or can i achieve the same if i useSqlConnection.BeginTransaction in my ASP.NET form or simple try catch may be...???

I tried implementing try catch in my stored procedure..i m using sql server 2005 but it does not know TRY and CATCH keywords or ERROR_MESSAGE() function...i also installed sql server 2005 service manager but still it does not work..

if an error is thrown using RAISERROR method will the exception will be shown in my ASP.NET form??

IrishChieftain · Accepted Answer · 2009-11-27 17:17:22Z

1

Surround the DB call in your code with the try-catch... try and put it at the level of the code-behind. If you are using a data access layer, put a try-catch there also, with a single throw statement. Then handle it in the code-behind when it bubbles up.

answered Nov 27, 2009 at 17:17

IrishChieftain

15.2k8 gold badges55 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nitai Bezerra · Accepted Answer · 2009-11-27 17:49:28Z

1

To use TRY...CATCH within SQL Server look this manual: http://msdn.microsoft.com/en-us/library/ms175976.aspx

BEGIN TRY
     { sql_statement | statement_block }
END TRY
BEGIN CATCH
          [ { sql_statement | statement_block } ]
END CATCH

You can catch the exception using catch (SqlException ex). You will find it in the System.Data.SqlClient namespace. You can also check the severity level.

edited Nov 27, 2009 at 17:49

answered Nov 27, 2009 at 17:30

Nitai Bezerra

4581 gold badge5 silver badges16 bronze badges

1 Comment

Nathan Koop Over a year ago

note link in answer is in Portuguese, here is the US english link msdn.microsoft.com/en-us/library/ms175976.aspx

Collectives™ on Stack Overflow

stored procedure exception handling in asp.net

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related