How do I get the Last Inserted ID?

Question

4.00/5 (1 vote)

See more:

First I inserted a value:

XML

QUERY( Insert into Table values ("TRY"))

Then I wanted to put the value of the last inserted id to a textbox. Since I do not know how to bind in textbox . I used gridview first.

XML

<pre lang="xml">QUERY(Select last_insert_id)
                   GRV_Dat7.DataSource = ds
                   GRV_Dat7.DataBind()
                   TextBox_IDNew1.Text = GRV_Dat7.Rows(0).Cells(0).Text</pre>

But this didnt work. Why? Can anyone help me? thanks.

Posted 13-Oct-14 17:43pm

NekoNao

Add a Solution

Comments

[no name] 14-Oct-14 1:10am

You can check with one query select Max(ID) from TableName

3 solutions

Solution 1

by using @@IDENTITY in sql server u will get last inserted id and using output parameters u can retrive that value in to ur code

Posted 13-Oct-14 18:02pm

Namith Krishnan E

Comments

SRS(The Coder) 14-Oct-14 0:14am

@@IDENTITY works across all scopes but i think here we need to use SCOPE_IDENTITY() as this is specific to particular scope we are inserted the record.

If we will go for using @@IDENTITY it will return the last inserted ID for any other insertion if made after yours within the same session.

Please look into this Article for further details :-
http://www.codeproject.com/Articles/103610/Difference-between-IDENTITY-SCOPE-IDENTITY-IDENT-C

Namith Krishnan E 14-Oct-14 0:21am

yes....u r right,iam assuming he is inserting into one table

Solution 2

Hi NekoNao,

In ASP.Net to get the last inserted id from SQL Server you can go like this :-

1) Write a procedure to insert the records by passing parameter as all the values you want to insert to a specific table. Also declare an extra output parameter to get the last inserted record id to the table in that scope.
Ex :-

SQL

CREATE PROCEDURE [dbo].[SP_InsertTestData]
(
      @Value1                VARCHAR(20)
    , @Value2                VARCHAR(MAX)
    , @Value3                VARCHAR(50) = ''
    , @LastInsertedRecordID  INT OUTPUT
)
AS
BEGIN
**********
END

2) You can get the last inserted record id using SCOPE_IDENTITY() method in SQL Server using just after the insertion operation then assign this value to the particular output parameter.
Ex:-

SQL

--Inside the procedure body
--Below statement goes just after insert statement
SET @LastInsertedRecordID = SCOPE_IDENTITY()

3) Now to get this ID in ADO.Net code and to set this value to a particular Label or TextBox is being explained here which might be further helpful for you.

Click Here[^]

Hope this definitely of help to you.

Posted 13-Oct-14 18:08pm

SRS(The Coder)

Updated 13-Oct-14 18:10pm

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh waran · Accepted Answer · 2014-10-13T18:08:00

Solution 3

simple try this,
select MAX(your_identityId) from table_name

bind this value to textbox which is in ur gridview.

Posted 13-Oct-14 18:08pm

Rajesh waran

Updated 13-Oct-14 18:12pm

v2

Comments

SRS(The Coder) 14-Oct-14 0:15am

This one is also helpful but need to know and use carefully.

Bhavikkumar Chaudhari 14-Oct-14 0:21am

Hi Gopu Raj,

You are right but there might be issue of concurrency.
If two users will do entry in same table simultaneously then issue will happen.

Better way is to use @@IDENTITY, it will return last identity value from table.

Rajesh waran 14-Oct-14 0:34am

s i agree,but i tried this query with my table simultaneously,it works,i can understand sometimes there will be some issues.