Server side save, sorting and export
Server side paging with uploading changes, sorting and export upon SQL database
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, ...).
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 all 4 SortingExport_*.aspx files.
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.
To permit 32bit application on 64bit IIS, go to IIS manager, display application pools list (usually in root under computer name).
Choose DefaultAppPool (or the pool you use for the ASP.NET applications the TreeGrid examples are run on), select Advanced configuration and set Permit 32bit application to true.
The pages are downloaded on demand from server (when the page is visible by scrollbars).
It is simple example with ineffective database access - it loads the whole table for every page and throws the rest away.
It also simply reloads all body when rows are added or deleted instead of handling changes in pages.