When you using server side pagination first you must check it out that on which page your record is exist. Like in my example I want to search ID number “17”. And on per page I am displaying total 10 numbers of rows/records so it means ID number “17” exist on page 2.
Copy and paste this example code which is more understandable.
Create database like "tutorials" and then create table "BOOKS_TBL" with more then 10 record. below is the script of table and data.