Server side paging with DLL on SQL database
Using TreeGrid server library for server side paging upon SQL database via .NET DataTable class and DbDataAdapter interface
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: DataTable.html
(this html page),
DBDef.xml
(static XML layout),
DataTable.aspx
(server script generates and processes XML data and generates XLS export; uses the TreeGrid.dll/so),
../Database.db
(source SQL database, table
TableData)
TreeGrid.dll
or
TreeGrid.so
library located in package root directory
/Server/ or
/Server/DLL64 depending on server system.
This library is used in DataTable.aspx.
tmp/
directory can be used for temporary data to free ASP.NET memory.
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 DataTable.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.
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.
This example demonstrates using
TreeGrid server side DLL / SO
library
for
server side
paging,
calculations,
grouping,
sorting,
filtering,
Excel export and
updates.
It uses generic ASP.NET
DataTable and
DbDataAdapter classes for SQL database access.
This example loads all data from database and fills them to TreeGrid DLL and uses it for generating data, pages and export for client.
Uploaded changes are sent to both database and TreeGrid DLL to be synchronized.