[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

scope_identity()

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
Contestoas
Asked:
Contestoas
1 Solution
 
SammyCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now