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

c# asp.net sql datatable datarow
Cindrella picture Cindrella · Aug 30, 2013 · Viewed 81.7k times · Source

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

Answer

Ehsan picture Ehsan · Aug 30, 2013

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

Related questions

Read SQL Table into C# DataTable

I've read a lot of posts about inserting a DataTable into a SQL table, but is there an easy way to pull a SQL table into a .NET DataTable?

Read More
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

I make an outer join and executed successfully in the informix database but I get the following exception in my code: DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat); Failed to enable constraints. One or more rows contain values violating non-null, unique, …

Read More
Index (zero based) must be greater than or equal to zero

Hey I keep getting an error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. My code: OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", …

Read More