hi friends,

Can i display the data in datagrid in pagewise manner.In my application i have large amount of data to show in a grid.is it possible that i can dispaly the data in page wise manner like we search in google & it display the result.
Plz help me I am using vb.net 2003 with MS-Access
thanks in advance

You could make two buttons on your form (one for previous and one for next) which increase and decrease a variable (let's call it 'count'.) Then in you SQL-syntax just use something like : SELECT * FROM foo LIMIT count,100 Then everytime one of the buttons is clicked, clear the datagrid and repopulate it with the new query.

Niek