我怎么不能在ASP中分配外键? [英] how can I don't assign a foreign key in asp?

问题描述

我有一个带有外键的类，在这里我从中定义一个对象并插入db中，我不分配外键，因为它必须在另一个页面中分配，并且我将外键分配为null，但是我得到了此错误:

无法将值NULL插入表"HomeWorkSystem.dbo.Course"的"GdtStdUN"列中；列不允许为空. INSERT失败.该声明已终止.

谢谢你

Hi, I have class that has a foreign key, where i define an object from it and insert in db i don''t assign foreign key because it must assign in another page and i assign foreign key to null but I get this error:

Cannot insert the value NULL into column ''GdtStdUN'', table ''HomeWorkSystem.dbo.Course''; column does not allow nulls. INSERT fails. The statement has been terminated.

thank you

推荐答案

在这里我从中定义一个对象并插入db中，我不分配外键，因为它必须在另一个页面中分配将外键分配为null，但出现此错误
定义外键会将外键约束放在该列上.似乎此约束已被定义为现在具有NOT NULL值，因此出现了错误.您必须将其定义为允许稍后引用的NULL.

此处的详细信息: MSDN:外键约束 [ ^ ]
MSDN:创建和修改外键约束 [ ^ ]

where i define an object from it and insert in db i don''t assign foreign key because it must assign in another page and i assign foreign key to null but I get this error
Defining a Foreign Key puts a foreign key constraint on that column. Looks like this constraint has been defined as having NOT NULL value right now, hence the error. You have to define it as NULL allowed to reference it later.

Details here: MSDN: FOREIGN KEY Constraints[^]
MSDN: Creating and Modifying FOREIGN KEY Constraints[^]

这篇关于我怎么不能在ASP中分配外键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！