About Grid

Question

Hi All,

I my application I have grid in I will bind the record from database. In that I have 500 records when I bind method to grid.

My question

1. In my grid I have max displaying record will be 50 means then the page load I need to get 1 to 50 records to display in the grid, that records only need to load from database?
2. When I click the page 2 then method should return 51 to 100 records?
3. How can i control the page number in the grid?