Bottom 10 records

How can i select the bottom 10 records in my table. Does the BOTTOM keyword work in VB.NET?

If you're using .NET 3.5 then you can use LINQ to DataSet:

vb.net Code:

Dim last10Rows = myDataTable.AsEnumerable().Skip(myDataTable.Rows.Count - 10)

The converse of Skip is Take, so to get the first 10 rows would be .Take(10).