What is the best way for handling Errors & giving Custom Error mes

[Guest]

Hi,

I am working on an ASP.Net (2.0) application with SQL 2K5. We need to
display customised error messages for both business validation errors from
the C# components as well as from the data base stored procedures. Could some
one suggest the best way to achieve this - also if any good article to know
more about this...

Thanks
Suhas