Select and display recent (newest) record in ASP.Net Core MVC

Hi rani,

You can use TOP caluse to select one record by using Order By Descending if its identity column.

SELECT TOP 1 * FROM Students ORDER BY Id DESC

Use the query in your SqlCommand.

If you dont have identity column then you need to addd the DateTime column to identify the last added record.