Server-Side Master Detail

In this example, we use two Tables - 'Categories' and 'Products'. The master Grid displays the 'Categories' table. When a row from the 'Categories' table is expanded, a detail Grid with 'Products' matching the expanded 'CategoryID' is displayed in a popup dialog.

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