Chapter 14 Inserting and Deleting Data with the ListView Control

winkimjr2 · May 17th, 2013, 02:37 PM

I did make the changes to handle the inserting as you suggested. However I am still getting the error I posted earlier

Code:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Picture_PhotoAlbum". The conflict occurred in database "Tester", table "dbo.PhotoAlbum", column 'Id'.
The statement has been terminated.

Imar · May 18th, 2013, 07:29 AM

And the error makes sense because of this:

Quote:

Here is what I see on the browser address bar
http://localhost:19074Site/ManagePho...PhotoAlbumId=0

You're passing zero to the ManagePhotoAlbum page which will try to insert a picture referencing an album with an ID of 0 which doesn't exist.

The problem can still be in the same areas as before:

1. You're not handling Inserted correctly.

2. Your database doesn't geberate the ID correctly.

For the first issue, can you post the full code (markup and code behind) of NewPhotoAlbum again?
For the second issue, ensure you set (Is Identity) on the Id colum of the PhotoAlbum table and then refresh the EF diagram if necessary (e.g. if Is Identity wasn't set).

Hope this helps,

Imar