Source files:

Schools.html

(this html page),

SchoolsDef.xml

(static XML layout),

Schools.aspx

(server script generates and processes XML data and manages users),

SchoolsRatings.aspx

(server script generates XML with user ratings),

SchoolsReview.aspx

(server script saves user review to db),

../Database.db

(source SQL database, tables Schools_Schools, Schools_Ratings, Schools_Reviews)

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 Schools.aspx, SchoolsRatings.aspx and SchoolsReview.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.

There are three modes to work with data:
a) View all data and rate and review the schools. Default mode, without log in.
b) Edit data as user . Every user has his own data. You can log in as Jan, Magda, David, Adam, Linda , all without password. Or you can add new user by entering new name and password.
c) Edit all data as administrator . You can edit all data or even assign it to another user. You can log in as Admin, without password.