Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to retrieve values from the last row in a DataTable?

I am having problems retrieving values from the last inserted row in a Data-table. I have a login form and the values will be inserted in the table has the ID (int,an auto incremented value), userID (int), logintime (smalldatetime) and logouttime(smalldatetime). The code which is used to inside the login button,it thus inserts all values except the log out time

DateTime t1 = DateTime.Now;
objbal2.insertLoginTime(s, t1);

and in the log out button I am updating the table, so I have to retrieve the last row values. I am updating the table with reference to the ID value and userID. Can I use this query get the values? But I can't figure out how?

SELECT COLUMN FROM TABLE ORDER BY COLUMN DESC

Thanks in advance

like image 426
Cindrella Avatar asked Aug 30 '13 08:08

Cindrella


2 Answers

if you have to read the values from last row then

DataRow lastRow = yourTable.Rows[yourTable.Rows.Count-1];

will return you last row. and you can read the values from it.

My second guess is that by datatable you are referring to table in sql server.

Then with small modification your query is fine as well.

SELECT TOP 1 COLUMN FROM TABLE ORDER BY COLUMN DESC
like image 198
Ehsan Avatar answered Oct 23 '22 11:10

Ehsan


var dt = new DataTable();
dt.AsEnumerable().Last();

dt.AsEnumerable() returns an IEnumerable<DataRow>

like image 32
Sruti Avatar answered Oct 23 '22 10:10

Sruti