Hi all...

     Can any one say, How to capture the exception in the ASP.NET, which actually has occured in the SQL Server.

regards,

jayahar

__________________
Regards,
Jayahar Aruchamy.
Life is all about expecting the unexpected.

Hi Jayahar,

           Are you familiar with MVC pattern. Because this pattern can help you to solve the problem with capturing exception.

            I will give you the easiest solution for a little web application. Make a group of class (buisness object) who will call the sql server where you will able to capture all exception and in your code behinde you will call theirs objects for saving, deleting and ect... With this your asp.net code will be separated of your buisness code and your data access.

        I hope that will help you. There is lot of pattern better of my little example but it better that capturing sql exception in your asp.net page. If i'm not enought clear just tell me, i will try to explain more clearly. My english is little bit bad sometime.

François

Try
  'Open sql connection
  'Command bla bla
  'datareader bla bla
  'Insert/update/delte
  'close cmd
  'close connection
catch E as exception
 response write(E.message)
 'or
 'Label1.text="sorry there is an error"
end try

Hope this helps


bdl