Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Basics If you are new to ASP or ASP.NET programming with version 3.5, this is the forum to begin asking questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 28th, 2010, 10:27 PM
Authorized User
Join Date: Aug 2010
Posts: 19
Thanks: 6
Thanked 0 Times in 0 Posts
Default 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.

Much appreciated,
  #2 (permalink)  
Old August 29th, 2010, 08:35 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts

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


Imar Spaanjaars
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!
The Following User Says Thank You to Imar For This Useful Post:
caiman (August 29th, 2010)
  #3 (permalink)  
Old August 29th, 2010, 12:24 PM
Authorized User
Join Date: Aug 2010
Posts: 19
Thanks: 6
Thanked 0 Times in 0 Posts

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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting a DetailsView Insert default value jpullam ASP.NET 2.0 Basics 13 April 7th, 2014 02:19 AM
Bulk Insert question iacon SQL Server 2005 2 October 2nd, 2007 06:51 PM
Moving the new/insert button on DetailsView jpullam ASP.NET 2.0 Basics 3 September 27th, 2007 05:29 PM
DropDownList value insert to MS DB(DetailsView) yukijocelyn ASP.NET 2.0 Basics 2 August 23rd, 2007 01:32 AM
Insert DropDownList(DetailsView) value toMS Access yukijocelyn ASP.NET 2.0 Professional 0 August 22nd, 2007 09:49 PM

All times are GMT -4. The time now is 04:07 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.