How to retrieve the last row record from database?

Question

1.00/5 (1 vote)

See more:

I would like to retrieve the latest record from database, what should I do?

C#

SqlConnection con = new SqlConnection(conStr);
            con.Open();

            SqlCommand cmdReserveID = new SqlCommand("SELECT ReserveID From Reservation", con);
            SqlDataReader rdr = cmdReserveID.ExecuteReader();

            rdr.Read();
            Label2.Text = rdr["ReserveID"].ToString();
            con.Close();

Posted 2-Aug-14 3:02am

AlexanderYap

Updated 3-Aug-14 19:48pm

Kishor Deshpande

v3

Add a Solution

Comments

Mike Meinz 2-Aug-14 9:53am

To give a proper answer, it is necessary to know why you need to know the ReserveID of the last row in the database table?

Kishor Deshpande 4-Aug-14 1:47am

Why you need the last row?

1 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)

Dilan Shaminda · Accepted Answer · 2014-08-02T03:13:00

Solution 1

Try below query.This should work for you :-)

SQL

SELECT TOP 1 ReserveID FROM Reservation ORDER BY ReserveID DESC

I assumed your ReserveID column contains unique values

Posted 2-Aug-14 3:13am

Dilan Shaminda