%@ Page Language="vb" AutoEventWireup="true" Src="CodeBehind.aspx.vb" Inherits="TreeGrid"%>
Page with code behind
Uses code excluded to .vb file by @Page Src attribute, uses <form> submit and .NET DataTable class and DbDataAdapter interface
Source files: CodeBehind.aspx
(this html page and also includes CodeBehind.aspx.vb script),
DBDef.xml
(static XML layout),
CodeBehind.aspx.vb
(included server script generates and processes XML data),
../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 CodeBehind.aspx.
The 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.