INSERT and get the record back?

Wrox Programmer Forums

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
INSERT and get the record back?

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

June 28th, 2007, 07:30 PM

tal

tal is offline

Authorized User

Join Date: Apr 2007

Posts: 25

Thanks: 0

Thanked 0 Times in 0 Posts

Default

INSERT and get the record back?

hi guys
is there a way in asp.net to insert a record and recieve it back to a dataset?
(i don't want to use two separate queries, one for insert and one for select since 2 users may do that in the same time...)

Any ideas

Old

June 29th, 2007, 08:30 AM

tal

tal is offline

Authorized User

Join Date: Apr 2007

Posts: 25

Thanks: 0

Thanked 0 Times in 0 Posts

Default

OK, found the answer: use the OUTPUT clause, and query using an adapter to fill a dataset.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert record disabled	jking	Access	9	January 10th, 2006 04:31 PM
Insert new Record	priority05	Classic ASP Databases	2	September 6th, 2004 12:26 PM
Insert a record into a Database	ersp	Classic ASP Basics	3	May 9th, 2004 08:50 PM
submit to insert data and then click [BACK]	vincentc	Classic ASP Basics	0	September 9th, 2003 10:25 PM