INSERT 语句与 FOREIGN KEY 约束冲突

Question

myCommand = New SqlCommand(
"INSERT INTO tblBook(BookCode, BookTitle, Author, PublishingYear, 
                     Price, EnterDate, CatID, RackID, Amount) 
VALUES('" & txtBookCode.Text & "','" & 
            txtTitle.Text & "','" & 
            txtAuthor.Text & "','" & 
            txtPublishYear.Text & "','" & 
            txtPrice.Text & "', #" & 
            txtEnterDate.Text & "#, " & 
            txtCategory.ValueMember & "," & 
            txtRack.ValueMember & "," & 
            txtAmount.Text & ")"
, myConnection)

错误是：

INSERT 语句与 FOREING KEY 约束“FK_tblBook_tblCategory”冲突。这 数据库“CIEDC”、表“dbo.tblCategory”、列“CatID”中发生冲突。 该声明已终止。

这是因为我的数据库关系吗？

如何解决这个问题？

Answer 1

txtCategory.ValueMember 的值似乎与数据库中的有效类别 ID 不对应。

Answer 2

我认为有两种情况：

1.

在您的表 dbo.tblBook 中，它有一个名为 CatID 的列，作为 dbo.tblCategory 表的外键引用。您似乎正在尝试使用尚未创建的 CatID 属性。如果是这样，请返回并先创建一个 CatID。

2.

也许有多个外键与您的表相关。
如果您使用 sql server，那么下面的 sql 语句将帮助您找到所有这些，检查出来并删除剩余的，祝您好运！

    USE <database_name>;  
GO  
SELECT   
    f.name AS foreign_key_name  
   ,OBJECT_NAME(f.parent_object_id) AS table_name  
   ,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS constraint_column_name  
   ,OBJECT_NAME (f.referenced_object_id) AS referenced_object  
   ,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name  
   ,is_disabled  
   ,delete_referential_action_desc  
   ,update_referential_action_desc  
FROM sys.foreign_keys AS f  
INNER JOIN sys.foreign_key_columns AS fc   
   ON f.object_id = fc.constraint_object_id   
--WHERE f.parent_object_id = OBJECT_ID('HumanResources.Employee'); 
GO 
SELECT 
f.name AS foreign_key_name 
,OBJECT_NAME(f.parent_object_id) AS table_name 
,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS constraint_column_name 
,OBJECT_NAME (f.referenced_object_id) AS referenced_object 
,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name 
,is_disabled 
,delete_referential_action_desc 
,update_referential_action_desc 
FROM sys.foreign_keys AS f 
INNER JOIN sys.foreign_key_columns AS fc 
ON f.object_id = fc.constraint_object_id 
--WHERE f.parent_object_id = OBJECT_ID('HumanResources.Employee');