加载 DataSet 时什么触发了 ConstraintException? [英] What triggers ConstraintException when loading DataSet?

问题描述

如何找出违反约束的列和值?异常消息根本没有帮助:

How can I find out which column and value is violating the constraint? The exception message isn't helpful at all:

未能启用约束.一个或更多行包含违反的值非空、唯一或外键约束.

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

推荐答案

有一个名为 RowError 的属性可以查看.

There is a property called RowError you can check.

参见 http://dotnetdebug.ne​​t/2006/07/16/constraintexception-a-helpful-tip/

编辑添加此链接显示行的迭代以查看哪些有错误.

Edited to add this link showing iteration of rows to see which had errors.

http://www.devnewsgroups.net/组/microsoft.public.dotnet.framework.adonet/topic58812.aspx

这篇关于加载 DataSet 时什么触发了 ConstraintException?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！