DetailsView insert question

caiman · August 28th, 2010, 10:27 PM

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.

Much appreciated,
-Chris

Imar · August 29th, 2010, 08:35 AM

Hi Chris,

You can set up a QueryStringParameter for the data source control. This parameter then gets its value from the specified query string field and stores it in the MovieId field it is attached to.

For more info: http://msdn.microsoft.com/en-us/libr...parameter.aspx

Cheers,

Imar

caiman · August 29th, 2010, 12:24 PM

Using your advice, I was still having trouble figuring out how to actually get the DetailsView to insert the data using the query string. Then I realized I had the QueryStringParameter in the wrong place - it needed to be inside the InsertParameters, not the SelectParameters.

Now it works like a charm!

Thanks very much for your help.

-Chris