Server-side Tree Grid

Datagrid in this example is used as a Tree Grid. That is achieved by setting the dataSource's 'keyDataField' and 'parentDataField' properties. When a row is expanded the datagrid sends a request with the expanded row data object on the Server-Side Datasource. The server uses the SQL query sent by the Server-Side Datasource and returns the requested sub-rows collection. This example uses a demo server with AlaSQL that generates SQL to show how a real server might use the requests sent by the Datagrid. The Server-Side Datagrid usage does not have any restrictions on the server-side technologies used.

SQL Query