newbie: Getting the latest record in a DataTable in DataSet ??? - Jeff

Hey

.NET 2.0
Sql Server 2005

AFIAK when my .NET app starts it fills every DataTable objects in the
DataSet with data

I wonder how to retrieve the latest record from a DataTable in a DataSet?

any suggestions?

newbie: Getting the latest record in a DataTable in DataSet ??? - lass

Define latest record.

Is it the one with the highest primary key value? The highest time stamp
value?

Perhaps it's just a matter of ordering your data accordingly.

--
Lasse Vågsæther Karlsen
mailto:lasse@vkarlsen.no
http://presentationmode.blogspot.com/

It's the record with the highest primary key value... - Jeff

it is the record with the highest primary key value... each record also
contain a datatime value specifying when the record was created...

Hi,Just create a DataView with the correct sorting and it would be either the - Ignacio Machin \( .NET/ C# MVP \)

Hi,


Just create a DataView with the correct sorting and it would be either the
first or the last record in the DataView

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.