如何从数据库中检索最后一行记录？ [英] How to retrieve the last row record from database?

问题描述

我想从数据库中检索最新记录，我该怎么办？

 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（）; 

解决方案

尝试以下查询。这应该适合你:-)

  SELECT   TOP   1  ReserveID  FROM 预订 ORDER   BY  ReserveID  DESC  

我假设您的 ReserveID 列包含唯一值

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

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();

解决方案

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

SELECT TOP 1 ReserveID FROM Reservation ORDER BY ReserveID DESC

I assumed your ReserveID column contains unique values

这篇关于如何从数据库中检索最后一行记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！