Paging with sqldataadapter VB net

See more:

SQL

Hi,
I want to create paging with sqldataadapter in VB Net I made this query but it doesn't generate insert, delete and update statements and shows error in ORDER BY

SELECT        id, ar_dromologiou, date1, car_num, proion, egatastasi, kod_pelati, pelatis, dhmos, kilomtres, posostita_ltitra, komistro_rate, sinolo_komistro, shmaia, diodia, ploio, lipes_prosayx, exoda_odigou, sinokomsim, 
                         synolo_exodaod_prosayx, gen_sinolo, fpa, synolo_fpa, rate_dromologiou
FROM            Table_1
ORDER BY id OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

it shows data but I want to go to next page with binding navigator also, is there any other method for ado because ado does't accept 'declare' in query, like top?

TY

What I have tried:

the query above but doesn't generate insert,update,delete and doesn't move to next page