Find out which row/constraint triggers the constraint exception

[Guest]

When a dataset is modified and a constraint is violated, then there seems to be no way to find out which row/constraint violated the constraint. I get a System.Data.ConstraintException. However, there is no Row or Constraint property that informs which row violated which constraint.

This is especially hard, when you need to debug complex queries that are used in a DataAdapter. Is there a workaround to find out, which row/constraint triggers the constraint exception? It would be a great addition for the new ADO.NET v2.0 when this information will become available.

 

[Miha Markic [MVP C#]]

Hi Ramon,

Actually there is. Check DataRow.RowError property.
You might use also DataTable.HasErrors and DataRow.HasErrors properties to
filter your search.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

When a dataset is modified and a constraint is violated, then there seems

to be no way to find out which row/constraint violated the constraint. I get
a System.Data.ConstraintException. However, there is no Row or Constraint
property that informs which row violated which constraint.

This is especially hard, when you need to debug complex queries that are

used in a DataAdapter. Is there a workaround to find out, which
row/constraint triggers the constraint exception? It would be a great
addition for the new ADO.NET v2.0 when this information will become
available.