devexpress-examples/winforms-grid-load-refresh-detail-data-from-database

Dynamically load and refresh detail data (master-detail).

WinForms Data Grid - Dynamically load and refresh detail data from the database

This example shows how to load only the required data on demand when the detail view is open. This can be useful if the grid control is bound to a large set of detailed data and you do not want to load the entire data table. The example also shows how to update the data in the detail view without re-expanding the main row.

• Handle master-detail-related events to avoid excessive database queries.
• Reload the underlying data table to refresh a detail view. If the child list implements the IBindingList interface, the corresponding detail view will be automatically refreshed. Otherwise, you should explicitly call the RefreshData method.

Note

Consider using a WinForms Data Grid in server mode.

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Master-Detail Relationships
• Working with Master-Detail Relationships in Code

See Also

• DevExpress WinForms Cheat Sheets - XtraGrid Master-Detail Mode
• DevExpress WinForms Troubleshooting - Grid Control