Access DataBase_How to move next or move previous in C#

Question

Mine application is C# windows application. Is it any way that u can implement code so you can move through records with: move first move last, and move next. I know how to connect to database but this gives me the ability only to retrieve record, but not the abilty to search through records.

Answer 1

In ADO.NET 1.x a disconnected model is used, so you can only select the whole data at once and store it in memory (DataAdapter & DataSet) or you can select data row by row in a read-only forward-only manner (DataReader) In ADO.NET 2.0 however, a server-side cursor is implemented that maybe means that this is possible.

Answer 2

You cud better search for 'database' within www.c-sharpcorner.com site to find plenty of articles related to databases.