I am creating a custom built Table class control and retrieving records from Database. I want to create paging for the Table control.
- I have tried lots of different ways, but didn't work.

-In my project i am using only ASP Table control, so i dont want to use any data bound controls for paging.

-i tried using Paged data source.But i think the Table control should have the Data source property for that. So iam confused. Can somebody suggest me some ideas on how to create Paging since i am new to ASP.

Paging can occur on two levels, and I believe you've identified them. One technique is to return ALL data and use the data bound control to limit which ones are displayed. This is a very heavy technique especially if you have lots of records, but it's the way tools like GridViews manage, I believe. The alternative is to manage this from the data source control and only retrieve the specific rows you want.

Since you want to handle this in the data source end (which is generally the better idea) you need to look at the SQL syntax of your database MS SQL, MySQL, whatever and determine how to break a query into ranges. I believe they all support paging, but it's not part of the SQL standard, so each database has its own proprietary implementation.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.