The second module I developed was called XMLdb. This modules uses the "For XML" functionality of T-SQL along with power of XLST to provide some awesome results.
Recently, I rewrote a good portion of XMLdb to utilitize the revised ASP.NET V2.0 XML routines. Sadly, the existing module as still using the ASP.NET V1.0 methods, so the module was in need of some TLC.
To demostrate the power of the module, I developed an Paging Example using the Northwind database and the Customer table. While implementing paging is simple using the various grids, typically the performance suffers when the database table is larger. In most cases the entire table must be returned from the database the the grid selects the disired records for display ... all the other records are unused. On a 1,000,000 row table -- this can hurt performace especially if this is done several times as the user pages through the data. However there are alternatives, and this demostration illustrates such an alternative.
You can read about the demostration here, see it in action here, or download the sample code and modules here
Hope you enjoy this version of paging.
Paul.