You could accomplish this two ways 1) When you enter the record you could return the ID of the record (easy to do with a stored procedure -- look up @@Identity. And then pull the info back out using that ID 2) This option makes more sense to me.... you already have the info that the user entered. Just redisplay it for him. In other words ... if he is filling out a form then take all of the form values and throw them into a label or literal and push them back to the screen. That option makes more sense because the data is already there and you are not going back to the database. HTH Ronda
_____ From: sas0riza [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: [AspNetAnyQuestionIsOk] Displaying the Last Inserted Record After user fills in a form and hits submit, the data is entered into the database. *I also want to retrieve that same record (last entered record) and redisplay the info to the user letting him/her know that that info has been entered.* I'm not sure how to retrieve the last record. Do I need to loop through a table or? [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
