Server side paging with DLL on XML file
Using TreeGrid server library for server side paging upon XML file on disk
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:

File.html

(this html page),

FileDef.xml

 (static XML layout),

File.aspx

 (server script generates and processes XML data and generates XLS export; uses the TreeGrid.dll/so),

FileData.xml

 (source XML data)

TreeGrid.dll

or

TreeGrid.so

library located in package root directory /Server/ or /Server/DLL64 depending on server system. This library is used in File.aspx.

tmp/

directory can be used for temporary data to free ASP.NET memory.
This example demonstrates using

TreeGrid server side DLL / SO

 library for server side paging, calculations, grouping, sorting, filtering, Excel export and updates. It demonstrates also complex grouping feature and cell editing in various groups.
This example loads all data from the FileData.xml file and fills them to TreeGrid DLL and uses it for generating data, pages and export for client.
Uploaded changes are sent only to TreeGrid DLL and saved to temporary xml in /tmp directory. This example does not modify the source FileData.xml!
This example does not use any custom JavaScript or server script code, all features are set via XML data definitions and provided by TreeGrid!
In table there are fictive resellers around the world with their results from the first two months in year 2004.
In columns Registered, Since, Calls per and Rabat are data related to partner and can be edited only when rows are grouped by Partner (or by Location and Partner). In columns Orders, Income and Expenses are results from every partner's month and can be edited in any grouping.
Column Gross profit is calculated (Income - Expenses), Discount is calculated (Gross profit x Rabat) and Profit is calculated (Gross profit - Discount). In bottom Total results row is summary of the results for whole table, in individual group rows when the grid is grouped is summary for given group.
When are rows grouped by Location and Partner you can drag and drop partners to another location, add new partner to the location or delete the partner. You can also change the whole location by choosing another.