Knowing the Id of the last inserted row in asp.net and sql server?

Question

5.00/5 (1 vote)

See more:

Hi all ,

I am using typed datasets in asp.net,and i am inserting into one of the tables which have auto incremented primary key field.But i need to get the last value inserted in this field,which means the last row inserted in table.So how can i make it ?.I have already tried select identity but it did not work.So is there any other way ?

Thanks in advance.

Posted 25-Aug-11 7:59am

mhamad zarif

Add a Solution

3 solutions

Solution 3

you can try :

ID_of_last_record+1
or
Insert and return Last record

Posted 25-Aug-11 11:00am

Pradip_Bobhate

Comments

Philippe Mori 25-Aug-11 19:23pm

Might not works if there are concurrent access to the database...

Solution 4

In Visual Studio you can open your .xsd file and select the configure the table adapter. Select the "Advanced Options" button and select the "refresh data table" checkbox.

Posted 25-Aug-11 11:03am

bob4096

Comments

Philippe Mori 25-Aug-11 19:29pm

I wasn't not even aware of that option. I never have any problem with SQL Express and dataset...

I began to have some problems when I want to add support for other databases (SQL CE and SQLite - dropped before conversion completed as it was a bit simpler to support CE) but I have to make many workarounds to make code works also for that database. It was not my choice though.

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)

mhamad zarif · Accepted Answer · 2011-08-25T08:14:00

I have already figured it out.So for all people that wants a solution for the same issue.This is what i did :

I added a stored procedure to the database and here it is :

SQL

ALTER PROCEDURE dbo.StoredProcedure1


    @Inventory_Title nvarchar(500)


AS
INSERT INTO Inventory
                         (Inventory_Title)
VALUES        (@Inventory_Title)
Select SCOPE_IDENTITY()
    /* SET NOCOUNT ON */
    RETURN

Then i added a query into the table adapter,that has the stored procuder as its source.Then i called the method from the code using c# and this is the code :

C#

DataSet1TableAdapters.InventoryTableAdapter da=new DataSet1TableAdapters.InventoryTableAdapter();

C#

int id = Convert.ToInt32( da.InsertWithReturn("Inv1"));

And by this way i got the last inserted id.