I'm having an issue on Chapter 13, I successfully completed the "Managing Data with the DetailsView Control" Try it Out, I can insert and update entries in my database without any issues.

When I complete the last Try it Out, "Customizing the DetailsView and Handling Its Events", both insert and update stop working. I get no error messages after clicking "Insert" or "Update", but when I go check the entries, they aren't there.

I also checked the databases physically on Web Developer's Database Explorer, no content seems to be added to my database.

I've deleted the AddEditReview page and restarted the Try it Outs and it's always the same result, first Try it Out works fine, second Try it Out - no dice. I've gone as far as compare your source with mine, and I can't seem to find any difference. Except that when I run your exercise it works...

Any idea what this could be? Thank you for your time.

After looking at this for hours, I decided to just change what I knew was different. Our database.

I remade the tables and it's now working, I still don't get why it wasn't before.

I messed a lot with the data inside the tables (eventually led to my first Review ID being 7 and my first Genre ID being 3), I'm not sure if this has something to do with not working, but "tidying" up my IDs seems to have worked...

Hi there,

The actual IDs shouldn't make a difference. But maybe you didn't create the necessary primary keys on the Id columns of the database or create a relationship between the two tables? Those are the two most common issues...

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!