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

Hi,

I don't think it is possible to achieve what you are looking with a single select query.

You won't get distinct from every columns while selecting multiple columns. Because distinct keyword considers whether a single row is distinct or not. Not a column. Please have a look at below link -

http://dba.stackexchange.com/questions/102677/select-distinct-on-multiple-columns

Answer 2

your logic is true

could you post the screenshots of the table with data