hi 
 

Try this query to reterive records 

select top 5 * from order where order_id in ( select top 10 from order 
order by order_id asc)order by order_id desc

this query will return u records between 5 and 10 
u can change the number of records by changing the values of 5 and 10 
respectively bind the data into datagrid . on next button u can increment 
the values of 10 and can call datagrid again. this way paging will be 
implemented.

Umar
Islamabad
Pakistan