Server side grouping
Server side root paging with grouping rows on server with client side child paging
Do not run this file locally!
Run it from your local or remote web http server where is installed IIS and ASP.NET (1.0, 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, ...).
Source files:

Grouping.html

(this html page),

Grouping_Layout.xml

 (static XML layout),

Grouping_Data.aspx

 (server script generates XML list of pages),

Grouping_Page.aspx

 (server script generates XML for individual page),

../Database.db

(source SQL database, table TableData)
This example uses

SQLite

../Database.db file as source SQL database. You can switch to

MS Access

MDB database by setting UseMDB property to true in Grouping_Data.aspx and Grouping_Page.aspx.
The MS Access MDB database can be used only in 32bit mode of IIS. Also the ASP.NET service program must have write access to the Database.mdb file.
Demonstrates server root paging but client child paging - all children from groups are downloaded from server at once. There is no server communication on parent row expand.
This is only simple example with not ideal database access (for every page gets all data). The root pages are downloaded on demand from server (when the page is visible by scrollbars).