Solved

scope_identity()

Posted on 2006-06-19
3
551 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 earned 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# MVC and a global static factory that never dies 4 58
Need help with building query string 2 19
encoding an href string 2 20
ASP.NET MVC -Add authentication 2 21
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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

773 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