Grid from database table
Generates grouped grid from plain table by dynamic layout script
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, ...).
Generates treetable from standard database table. Also flips the table and shows data in changed layout.
For every action there is used another support code (Layout, Data, Upload). The layout is also generated.
Rows are identified by one unique editable column, with using full ids (including parents ids).
For demonstration it shows id column, to see what ids are generated by TreeGrid.
Source files: Grid.html
(this html page),
GridLayout.aspx
(server script generates XML layout),
GridData.aspx
(server script generates XML data),
GridUpload.aspx
(server script saves XML changes),
../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 GridLayout.aspx, GridData.aspx and GridUpload.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.