>我有这些表:
TABLE_DIRECTOR
-directorID
-name
-adres
-birthDate
-yearsExperience
TABLE_FILM
-filmID
-directorID
-filmstudioID
-title
-budget
-filmstudioName
-directorName
TABLE_FILMSTUDIO
-filmstudioID
-name
-website
-foundingDate
-numberOfBuildings
我要做的是用所有filmdirectors
填满detailsview
。我还有一个gridview
里面装满了directors
合作过的所有filmstudio
。
为了填写这个gridview
我在我的TABLE_FLMSTUDIO_TABLEADAPTER
中输入了以下代码:
SELECT TABLE_FILMSTUDIO.filmstudioID, TABLE_FILMSTUDIO.name,
TABLE_FILMSTUDIO.website, TABLE_FILMSTUDIO.foundingDate,
TABLE_FILMSTUDIO.numberOfBuildings
FROM TABLE_FILMSTUDIO INNER JOIN
TABLE_FILM ON TABLE_FILMSTUDIO.filmstudioID = TABLE_FILM.filmstudioID
WHERE (TABLE_FILM.directorID = @directorID)
但是,当我运行页面时,这给了我以下错误
Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key constraints.
有人有想法吗?
第一件事:TABLE_FILM -filmID -directorID -title -budget -filmstudioName -directorName 不包含filmstudioID,但你在INNER JOIN中使用它作为TABLE_FILM.filmstudioID。
其次,错误表明您的一个表包含重复数据。( 违反外键 )