>>I am looking for input on how your UI layer handles messages of failure to update database because of constraint violation. For example, if a user enters a value in a FK column that has not match in UNIQUE field of primary table, this will cause the update to return an error. The error message is very long and very technical in nature. Do you show the entire message to your users and hope they understand? Or what other approaches you use?
>
>I always use an approach like this:
>
>

>            Try
>                oDataAdapter.Fill(oDataSet)
>            Catch loError As Exception
>                cError = loError.Message
>
>                ' Try to extrapolate
>                Select Case cError
>
>                    Case "External table is not in the expected format."
>                        cError = aMessage(1, nLanguage)
>
>                    Case "'Schema$' is not a valid name.  Make sure that it does not include invalid characters or punctuation and that it is not too long."
>                        cError = aMessage(2, nLanguage)
>
>                End Select
>
>                Return False
>            End Try
>

>
>So, basically, if there are any specific errors you would like to catch, you can had a hook in there. Otherwise, it would be the error returned by the exception.

Thank you. And I understand that the code above is part of your BIZ class, right?