Gantt Run database
Creates Gantt Run data from and saves changes back to database using AJAX and .NET IDbCommand and IDataReader interfaces
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: RunDB.html
(this html page),
RunDBDef.xml
(static XML layout),
RunDBData.aspx
(server script generates XML data),
RunDBUpload.aspx
(server script saves XML data to database),
../Database.db
(source SQL database, table
Run),
RunSources.xml
(static XML layout and data for right grid),
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 GanttBasicDBData.aspx and GanttBasicDBUpload.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 Continuous Run, complex and universal bar type. It supports more bars in one cell, with different features, size, color, class, text and tooltip.
For more Gantt Run features see Gantt Local examples or Gantt tutorials.
For more ways of database communication see Basic Ajax or Form Submit ASP.NET examples.