How To get last inserted value in the table sql server c#

Question

1.44/5 (4 votes)

See more:

I want to get the last inserted groupID int the table ProjectGroup

Here is the table

ProjectGroup
*GroupID
*GroupName
*ProjectName

Posted 13-Jun-14 3:06am

Member 10239837

Add a Solution

Comments

DamithSL 13-Jun-14 9:13am

what is the type of GroupID? is it auto number or auto increment?

Member 10239837 13-Jun-14 9:13am

Auto Increment

3 solutions

Solution 3

Refer:
1. get-the-last-inserted-row-id-with-sql-statement[^]
2. Best way to get identity of inserted row?[^]
3. sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/[^]

Posted 13-Jun-14 3:17am

Peter Leow

Solution 2

You have provided a list of columns, but no indication of the data type or usage.
Is the GroupId an identity field that automatically increases when a record is inserted?

If that is the case, then select the record with the maximum group id.

If, however, the group id can be inserted in any order, then you need to have a field that indicates the insertion order, such as insertion date. In this scenario, you can use the maximum insertion date.

Posted 13-Jun-14 3:14am

Tim Carmichael

Comments

goathik 13-Jun-14 9:17am

nah, just try my solution ;)

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)

goathik · Accepted Answer · 2014-06-13T03:13:00

Solution 1

here's the SQL:

SQL

SELECT TOP(1) GroupID FROM ProjectGroup ORDER BY 1 DESC

let me know if you need any code in C# using ADO or Linq

Posted 13-Jun-14 3:13am

goathik

Comments

Member 10239837 13-Jun-14 9:18am

Thank you very much it is working

Member 10239837 13-Jun-14 10:01am

can you give me the code in c# please

goathik 13-Jun-14 12:35pm

sure, just a sec

goathik 13-Jun-14 12:41pm

SqlConnection connection = new SqlConnection(connectionstring);
SqlCommand command = new SqlCommand("SELECT TOP(1) GroupID FROM ProjectGroup ORDER BY 1 DESC",connection);

connection.Open();
SqlDataReader reader = command.ExecuteReader();

//won't need a while, since it will only retrieve one row
reader.Read();

//here is your data
string data = reader["GroupID"].ToString();

reader.Close();
connection.Close();