Retrieve Last Record

[asafb]

Hello, I have a datagrid which is bounded using the databind feature. The SQL is SELECT * FROM customers for example, and it shows a beautiful grid! Now, I want it to display just teh LAST row from that table. How the heck do you do that in ADO.NET / ASP.NET land? With ASP classic, you do RST.MOVENEXT.

THANKS!!!!!!!
AB

 

[BoulderBum]

You can index DataTable.Rows[0] of a DataTable, or implement filtering with a DataView (or use the DataSet.Select() method, etc., etc.).

With ADO.NET objects, the resultset is disconnected. All of the data is there for you to work with.

If you don't want to use the disconnected objects, I suppose you can also call DataReader.Read() for the equivalent of MoveNext.