How can i select the bottom 10 records in my table. Does the BOTTOM keyword work in VB.NET?
Printable View
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:The converse of Skip is Take, so to get the first 10 rows would be .Take(10).vb.net Code:
Dim last10Rows = myDataTable.AsEnumerable().Skip(myDataTable.Rows.Count - 10)