Visual Basic .NET's version of dlook or goto first record or goto last record

[maxamis4]

I want to find out what the last record is and the first how is this done in vb.net if eof and bof are gone?

[bplacker]

if you want to move to the first or last.. do something like this:

dim firstRec, lastRec as integer
firstRec = 0
lastRec = DataSet1.Tables("TableName").Rows.Count - 1

DataSet1.Tables("TableName").Rows(firstRect)....

DataSet1.Tables("TableName").Rows(lastRec)...