Your search did not match any results.
Data Grid

Advanced Master-Detail View

This demo illustrates an advanced master-detail view in the DataGrid widget. Master rows represent suppliers. Detail sections contain TabPanel widgets with two tabs: Orders and Address. In the Orders tab, you can choose a supplier's product from the SelectBox, and the DataGrid under it will show orders placed on this product. The Address tab displays the supplier's address.

Copy to CodeSandBox
Apply
Reset
<dx-data-grid id="gridContainer" [dataSource]="suppliersData" [remoteOperations]="true" [showBorders]="true" > <dxo-paging pageSize="15"></dxo-paging> <dxi-column dataField="ContactName"></dxi-column> <dxi-column dataField="ContactTitle"></dxi-column> <dxi-column dataField="CompanyName"></dxi-column> <dxi-column dataField="City"></dxi-column> <dxi-column dataField="Country"></dxi-column> <dxo-master-detail [enabled]="true" template="masterDetail"></dxo-master-detail> <div *dxTemplate="let masterDetailItem of 'masterDetail'"> <dx-tab-panel> <dxi-item title="Orders" template="ordersTab"></dxi-item> <div *dxTemplate="let ordersTabItem of 'ordersTab'"> <dx-form labelLocation="top" class="form-container"> <dxi-item template="productSelectBox"> <dxo-label text="Product"></dxo-label> </dxi-item> <div *dxTemplate="let selectBoxItem of 'productSelectBox'"> <dx-select-box [value]="productIdBySupplier[masterDetailItem.key]" [dataSource]="getProductsData(masterDetailItem.key)" [deferRendering]="false" valueExpr="ProductID" displayExpr="ProductName" (onValueChanged)="handleValueChange($event, masterDetailItem.key)" > </dx-select-box> </div> <dxi-item template="orderHistory"> <dxo-label text="Order History"></dxo-label> </dxi-item> <div *dxTemplate="let order of 'orderHistory'"> <dx-data-grid [dataSource]="getOrderHistoryData(masterDetailItem.key)" [showBorders]="true" > <dxo-paging [pageSize]="5"></dxo-paging> <dxi-column dataField="OrderID"></dxi-column> <dxi-column dataField="OrderDate" dataType="date"></dxi-column> <dxi-column dataField="ShipCountry"></dxi-column> <dxi-column dataField="ShipCity"></dxi-column> <dxi-column dataField="UnitPrice" format="currency"></dxi-column> <dxi-column dataField="Quantity"></dxi-column> <dxi-column dataField="Discount" format="percent"></dxi-column> <dxo-summary> <dxi-total-item column="UnitPrice" summaryType="sum"> <dxo-value-format format="currency" [precision]="2" ></dxo-value-format> </dxi-total-item> <dxi-total-item column="Quantity" summaryType="count"></dxi-total-item> </dxo-summary> </dx-data-grid> </div> </dx-form> </div> <dxi-item title="Address" template="addressTab"></dxi-item> <div *dxTemplate="let addressTabItem of 'addressTab'"> <dx-form [formData]="masterDetailItem.data" [colCount]="2" [customizeItem]="customizeItemTemplate" class="address-form form-container" > <dxi-item dataField="Address"></dxi-item> <dxi-item dataField="City"></dxi-item> <dxi-item dataField="Region"></dxi-item> <dxi-item dataField="PostalCode"></dxi-item> <dxi-item dataField="Country"></dxi-item> <dxi-item dataField="Phone"></dxi-item> <div *dxTemplate="let item of 'formItem'"> <span>{{item.editorOptions.value}}</span> </div> </dx-form> </div> </dx-tab-panel> </div> </dx-data-grid>
import { NgModule, Component, enableProdMode, ChangeDetectionStrategy } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxDataGridModule, DxFormModule, DxSelectBoxModule, DxTabPanelModule } from 'devextreme-angular'; import * as AspNetData from "devextreme-aspnet-data-nojquery"; if(!/localhost/.test(document.location.host)) { enableProdMode(); } @Component({ selector: 'demo-app', templateUrl: 'app/app.component.html', styleUrls: ['app/app.component.css'], }) export class AppComponent { url: string; suppliersData: any; productsDataMap: object = {}; productIdBySupplier: object = {}; orderHistoryDataMap: object = {}; constructor() { this.url = "https://js.devexpress.com/Demos/Mvc/api/DataGridAdvancedMasterDetailView"; this.suppliersData = AspNetData.createStore({ key: "SupplierID", loadUrl: this.url + "/GetSuppliers" }); } handleValueChange(e: any, supplierID: number) { this.productIdBySupplier[supplierID] = e.value; this.orderHistoryDataMap[supplierID] = { store: AspNetData.createStore({ key: "OrderID", loadParams: { ProductID: e.value }, loadUrl: this.url + "/GetOrdersByProduct" }) }; } customizeItemTemplate(item: any) { item.template = "formItem"; } getProductsData(supplierID: number) : any { return this.productsDataMap[supplierID] = this.productsDataMap[supplierID] || { store: AspNetData.createStore({ key: "ProductID", loadParams: { SupplierID: supplierID }, loadUrl: this.url + "/GetProductsBySupplier", onLoaded: items => this.setDefaultProduct(items, supplierID) }) }; } setDefaultProduct(items, supplierID) { let firstItem = items[0]; if(firstItem && this.productIdBySupplier[supplierID] === undefined) { this.productIdBySupplier[supplierID] = firstItem.ProductID; } } getOrderHistoryData(supplierID: number) : any { return this.orderHistoryDataMap[supplierID]; } } @NgModule({ imports: [ BrowserModule, DxDataGridModule, DxFormModule, DxSelectBoxModule, DxTabPanelModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep #gridContainer { height: 620px; } ::ng-deep .dx-datagrid-rowsview .dx-master-detail-row:not(.dx-datagrid-edit-form) > .dx-datagrid-group-space, .dx-datagrid-rowsview .dx-master-detail-row:not(.dx-datagrid-edit-form) .dx-master-detail-cell { background-color: transparent; } ::ng-deep .form-container { padding: 20px; } ::ng-deep .address-form label { font-weight: bold; }
// In real applications, you should not transpile code in the browser. You can see how to create your own application with Angular and DevExtreme here: // https://github.com/DevExpress/devextreme-angular/blob/master/README.md System.config({ transpiler: 'ts', typescriptOptions: { module: "commonjs", emitDecoratorMetadata: true, experimentalDecorators: true }, meta: { 'typescript': { "exports": "ts" }, 'devextreme-aspnet-data-nojquery': { "esModule": true } }, paths: { 'npm:': 'https://unpkg.com/' }, map: { 'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js', 'typescript': 'npm:typescript@3.4.5/lib/typescript.js', '@angular/core': 'npm:@angular/core@8.0.0/bundles/core.umd.js', '@angular/common': 'npm:@angular/common@8.0.0/bundles/common.umd.js', '@angular/compiler': 'npm:@angular/compiler@8.0.0/bundles/compiler.umd.js', '@angular/platform-browser': 'npm:@angular/platform-browser@8.0.0/bundles/platform-browser.umd.js', '@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic@8.0.0/bundles/platform-browser-dynamic.umd.js', '@angular/router': 'npm:@angular/router@8.0.0/bundles/router.umd.js', '@angular/forms': 'npm:@angular/forms@8.0.0/bundles/forms.umd.js', '@angular/common/http': 'npm:@angular/common@8.0.0/bundles/common-http.umd.js', 'tslib': 'npm:tslib/tslib.js', 'rxjs': 'npm:rxjs@6.3.3', 'rxjs/operators': 'npm:rxjs@6.3.3/operators', 'devextreme': 'npm:devextreme@19.2', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'quill': 'npm:quill@1.3.6/dist/quill.js', 'devexpress-diagram': 'npm:devexpress-diagram', 'devexpress-gantt': 'npm:devexpress-gantt', 'devextreme-angular': 'npm:devextreme-angular@19.2', 'devextreme-aspnet-data-nojquery': 'npm:devextreme-aspnet-data-nojquery@2.4.2' }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts' }, 'devextreme': { defaultExtension: 'js' }, 'rxjs': { main: 'index.js', defaultExtension: 'js' }, 'rxjs/operators': { main: 'index.js', defaultExtension: 'js' }, 'devextreme-angular': { main: 'index.js', defaultExtension: 'js' } } });
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.6/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.6/css/dx.light.css" /> <script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script> <script src="https://unpkg.com/zone.js@0.6.25/dist/zone.js"></script> <script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script src="config.js"></script> <script> System.import('app').catch(console.error.bind(console)); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <demo-app>Loading...</demo-app> </div> </body> </html>