DetailsView insert question
In my site I'm allowing users to write reviews of movies. Each movie has its own page with a link for the user to follow to write a review for that movie using a DetailsView. In my database each movie has its own MovieId. When a user writes a review, the MovieId field is filled in for him (I don't want the users to have to know the MovieId of the movie they're writing about).
What I need is an insert statement that includes the MovieId automatically. I could put the MovieId in the insert statement explicitly, but then I would have to have a different "Add a Review" page for every single movie. What I want instead is just a single "Add a Review" page that knows which movie the user is writing about based on which page he just came from. For instance, if the user is on the Aliens page and clicks the link to write a review, he is taken to the Add a Review form, fills in the user name, title, and review, hits insert, and the DetailsView knows to insert the review with 10005 as the MovieId (MovieId for Aliens = 10005).
If there are multiple solutions for this, I would be interested in hearing them.