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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.