加载数据集时,是什么触发ConstraintException? [英] What triggers ConstraintException when loading DataSet?
问题描述
我如何找出哪些列和值违反约束?异常消息是没有帮助的,在所有的:
未能启用约束。一个或 多行中包含违反 非空,唯一或外键 约束。
有一个名为RowError属性,你可以检查。
请参阅<一href="http://dotnetdebug.net/2006/07/16/constraintexception-a-helpful-tip/">http://dotnetdebug.net/2006/07/16/constraintexception-a-helpful-tip/
编辑添加链接显示的行,看看其中有误差的迭代。
<一个href="http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic58812.aspx">http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic58812.aspx
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.
There is a property called RowError you can check.
See http://dotnetdebug.net/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/group/microsoft.public.dotnet.framework.adonet/topic58812.aspx
这篇关于加载数据集时,是什么触发ConstraintException?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!