Browse by Tags

Home ›

How to Capture Scope_Identity Value with Server Transfer

Hello all I'm working on a 2 page form. I want to submit the data on the first page, collect the scope identity, and us it as the id when submitting the rest of the data on page 2. I'm using VB, I have all my vb in one class called "contact" but have given each aspx page its on function...

Posted to Data Presentation Controls (Forum) by Redspringer on 12-23-2008, 12:00 AM
Filed under: SQL-Server, stored Procedures, Visual Studio 2008, VS 2005, Scope_Identity
SELECT @RETURN_VALUE = SCOPE_IDENTITY() - Only Works Sometimes?

I have a formview where the new record is created, but only sometimes does it pull the id of the recently inserted record. Can you guys look and tell me whats wrong? QUERY>>>>>>>>>>>>>>>>>> <asp:SqlDataSource ID="FormviewSqlDataSource1"...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jfierst on 07-09-2008, 12:00 AM
Filed under: Scope_Identity, sql express
Re: Return the ID of a newly inserted row.

Thank you for your response, BUT... I've spent 2 and a half days trying to figure this out... and it's just not getting easier. I've diligently tried the methods listed on this post (and many other blogs/posts) with absolutely no success. Again, I'm using: Visual Web Developer 2005 (not...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mr.Bill on 06-09-2008, 12:00 AM
Filed under: scalar-valued functions, scope_identity, @@IDENTITY Primary Key Return Value Stored Proc AutoNumber
Re: Getting the automatically generated id after SqlDataSource.Insert()

Take a look at this FANTASTIC tutorial: http://www.asp.net/learn/data-access/tutorial-01-cs.aspx This tutorial has helped me a lot and I am using it now to build an application for our company. Here you will see detailed instructions on how to create different queries and retrieve the id using SELECT...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cunharubens on 08-24-2007, 12:00 AM
Filed under: scope_identity
Re: Doing a double insert using FormView insert and SqlDataSource

Execute scalar, would normally execute the defined sql command. Hence if you put e.Command.ExecuteScalar() in the ..._dataInserted Method of your datasource object or the formview's datainserted event it will cause a second insert. If you want to use the idendity or scope_idendity() have a look at...

Posted to Web Forms (Forum) by abhm on 07-27-2007, 12:00 AM
Filed under: Scope_Identity, sql, Identits seed
Using SELECT SCOPE_IDENTITY in an ad-hoc query

I've got an insert command in an SqlDataSource control that looks like this: InsertCommand ="INSERT INTO TAG2(TagText) VALUES (@TagText); SELECT SCOPE_IDENTITY()" Is this correct? How do I get at the value of the identity so I can use it in another insert command?

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Disco Patrick on 07-24-2007, 12:00 AM
Filed under: Scope_Identity, ad hoc query
Re: Gridview - Detailsivew: How do I get the Gridview to select the last inserted record from the detailsview?

Hi Rafa, thanks for the quick reply! I tried what you said, I translated to VB as the following: Protected Sub DSDemoInfo_Inserted( ByVal sender As Object , ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles DSDemoInfo.Inserted Session( "decRetID" ) = e.ReturnValue End Sub...

Posted to Data Presentation Controls (Forum) by wadewalker25 on 02-02-2007, 12:00 AM
Filed under: rowdatabound gridview, databind, DetailsView, GridView, Scope_Identity
Gridview - Detailsivew: How do I get the Gridview to select the last inserted record from the detailsview?

How do I make the gridview go to a particular record without using the SelectedIndex? I have a GridView and DetailsView both on one page. I use Selection on the GridView to pull data from a particular table to populate data on the DetailsView. No problem thus far. However, when I insert a record using...

Posted to Data Presentation Controls (Forum) by wadewalker25 on 02-01-2007, 12:00 AM
Filed under: DetailsView, last inserted id, GridView, Scope_Identity
Re: Selecting the correct record on Gridview from inserting new record using Detailsview...

First, I love you guys and your quick responses!! Yeah I thought about setting the Gridview.SelectIndex = someintegervalue...however, that would mean that I would have to go through every single item in the Gridview list to compare against what I want. What if I have over 1000 records? That's what I...

Posted to Data Presentation Controls (Forum) by wadewalker25 on 02-01-2007, 12:00 AM
Filed under: databind, DetailsView, GridView, Scope_Identity
Re: @@identity

Lee Dumond: If the connection is built into the object, you have a TableAdapter that is connected to the table you are using. This TableAdapter contains methods that pull data from the table, like Fill() and GetData(). You can easily add another method to this TableAdapter to get the last value that...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by juliabeach on 11-14-2006, 12:00 AM
Filed under: scope_identity, insert, bll, dal

Page 1 of 2 (14 items) 1 2 Next >

Browse by Tags

Related Posts