Just wrap the calls to the Update method inside a try/catch. Will that work for you?
~~Bonnie
>Hi All
>
>I have a standard windows form employing a standard BindingNavigator control that is bound to a standard BindingSource control that is bound to a sqlTableAdapter object inside a sqlDataSet object.
>
>I need to be able to trap sqlException events that occur as a result of Insert / Update conflicts when my data is updated at the SQLServer.
>
>Is it possible to use event handlers to trap sqlException events that occur on data updates, if so what are the Objects and their related Events that I need to handle or must I use a different approach ?
>
>Jarid