select command using oledb data base

[celvice]

i have multiple data in my data base. Im using C# form And i created 2 buttons that have the function of previous and next. I dont know what will do to make this 2 buttons funtionable.

[nico5038]

Hmm, I'm no C# expert, but it looks to me you'll need to issue queries that are collecting the data using a < or > comparison of the keyvalue on the displayed form.
For getting the next records use:
select * from tblX where Key > "<substitute present key>" Order by Key
for previous records:
select * from tblX where Key < "<substitute present key>" Order by Key Desc
The OrderBy will give the first record to be the needed one.

Ofcourse EOF and BOF need to be taken care of.

Nic;o)