Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

scope_identity()

Posted on 2006-06-19
3
Medium Priority
?
562 Views
Last Modified: 2007-12-19
I have a formview with an iteminsert template. In the data source configuration I have set the insert method to point to a stored procedure that returns the scope_identity() value. The insert statement is automatically run when the user hits the insert button.

I need to retrieve this value from the item_inserted method.

Is this possible, or do I manually have to run the stored procedure in order to retrieve the return value.
0
Comment
Question by:Contestoas
3 Comments
 
LVL 27

Accepted Solution

by:
Sammy Ageil earned 2000 total points
ID: 16940112
You can do it using direction for the sql parameter object
take a look at the last example
http://aspnet.4guysfromrolla.com/articles/062905-1.aspx

HTH
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question