Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
ASP.NET - Error Handling in Database Stored Procedures
September 22, 2009
Would you please let me know whether we need to write exception handling mechanism (Try, Catch blocks) in database stored procedures? Is it the best Practice? (As the corresponding error will be thrown to the calling ASP.NET application itself whenever an error occurs in the database stored procedure.)
Thanks and Regards..
Posted Date: September 22, 2009 Points: 5
Yes its good idea to implement ERROR handler in stored procedure label in your business logic layer you should handle this or show this to user or as application demands.
below are some good tutorial to handle error in database label using SQL server
Mark As Answer if this solve your problem
To post reply
Related Questions Related Questions
ASP.NET - Working with Oracle 9i Database / Database Stored Procedures
Display data directly from database table to PDF using stored procedures in asp.net C#
How to Encrypt & Decrypt password and stored in database..
Create new Database connection error
how many nested levels are there in Sql Server 2008 for Stored Procedures?
Are stored procedures pre-compiled in Sql Server 2005?
Getting Error While storing data in database
stored procedures and fuctions
How to replace a tablename in all the stored procedures
Error: 4064 Ã¢â¬â Cannot open user default database. Login failed. Login failed for user
Latest Forum Questions From The Same Category
Slash(/) in Combobox
attaching the report in the web page
How do i get payment status in redirect page using bitpay?
Login with Facebook and Save details in database
Login with facebook account in my website
How to make a nested datalist control?
What class does Icon derive from?
What are the validation controls?
What''s the difference between an interface and abstract class?
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend