Grid Paging

Question

Dear Friends,

              
Please clarify my doubt in Grid virtual paging

Am binding the grid in page load ,my objective is If am
having 1000 records in my DB means I don't want to load all records in page load,
I want to load the records based on page index change.

Am having 10 records per each page, if am having 50 records
in db means it should be split up by 10 and it should display it 5 pages, If I
click the 2nd page it should be display 11 to 20 records.

If am having 15 records in my Db means paging must be 1 2 in first page 10
records, 2nd page 5 records likewise it should display

First page should display 10 records, when I click the
second page it should pick the next 10 records from Database.

How can I achieve this scenario?