The grid obtains its data from the Categories and Products tables in the NWind database. The Categories and Products tables are the master and detail tables, respectively. A master-detail relationship is established through the CategoryID field.
To retrieve data from the database, use the AccessDataSource components:
Detail: Products. Define a filter rule (see the image below).
2. Create Master and Detail ASPxGridView
Create two ASPxGridView controls. Bind the first grid (master) to the dsCategories. Bind the second grid (detail) to the dsProducts. Specify data source key fields for both grids using their ASPxGridBase.KeyFieldName property.
3. Set up a Master-Detail Relationship
Invoke ASPxGridView's Template Designer by clicking the Edit Templates task. Select the DetailRow template.
Drag the detail grid onto the Detail Row template.