For your solution you need to do like this..
1) First of all all the 100 record will fetch from database in only fist hit...
2) using data set you need to fill that all record to your data set..
3) now create one table from data set and fetch first 10 record from it.. then next 10 then next 10...
so using ADO.NET you can reduce your data base call and use a disconnected architecture benefit for it so your network traffic will reduce as per your requirement....
for more information on ADO.NET please see this links...
http://msdn.microsoft.com/en-us/library/ms971481.aspx[
^]
Using ADO.NET for beginners[
^]