Even for a simple project, you need to avoid retrieving all table records in a query for performance reasons so you have to do custom paging.
If you have searched for examples of custom paging using TableAdapters you’ll probably find out that custom paging is implemented using stored procedures.
In this post I show how you can add custom paging to your TableAdapter without using stored procedures and with very little code.