Drag & Drop Between Two Grids
This functionality requires that data objects have a data field that identifies which grid they belong to. In this demo, this data field is Status.
To allow users to move rows between grids, follow these steps:
-
Bind the grids to the same store
The store should be able to update data. In this demo, the store is created using the createStore method (part of the DevExtreme.AspNet.Data extension). The specifiedupdateUrlenables the store to update data. -
Specify grid identifiers
Save them in the rowDragging.data option. The grids below have identifiers 1 and 2. -
Filter the grids to display different record sets
Use the identifiers in the filterValue option to filter the grids. The grids below display only the records whoseStatusfield equals the grid's identifier. -
Join the grids into one drag and drop group
Set the rowDragging.group option to the same value for all grids to allow moving rows between them. -
Update the data field that specifies where the row belongs
Implement the rowDragging.onAdd function. To access the target grid's identifier, use thetoDatafunction parameter. Call the store's update method to send this identifier to the server and push the same changes to the store on the client. The grids are refreshed automatically if you enable reshapeOnPush in the dataSource.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
<div class="tables">
<div *ngFor="let status of statuses" class="column">
<dx-data-grid
[dataSource]="dataSource"
[height]="440"
[showBorders]="true"
[filterValue]="['Status', '=', status]">
<dxo-row-dragging
[data]="status"
group="tasksGroup"
[onAdd]="onAdd"
></dxo-row-dragging>
<dxo-scrolling mode='virtual'></dxo-scrolling>
<dxi-column
dataField="Subject"
dataType="string"
></dxi-column>
<dxi-column
dataField="Priority"
dataType="number"
[width]="80" >
<dxo-lookup
[dataSource]="priorities"
valueExpr="id"
displayExpr="text"
></dxo-lookup>
</dxi-column>
<dxi-column
dataField="Status"
dataType="number"
[visible]="false"
></dxi-column>
</dx-data-grid>
</div>
</div>
import { NgModule, Component, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { DxDataGridModule } from 'devextreme-angular';
import { Priority, Service } from './app.service';
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'],
preserveWhitespaces: true,
providers: [Service]
})
export class AppComponent {
statuses: Array<number>;
dataSource: any;
priorities: Array<Priority>;
url: string;
tasksStore: any;
constructor(service: Service) {
this.url = "https://js.devexpress.com/Demos/Mvc/api/DnDBetweenGrids";
this.priorities = service.getPriorities();
this.statuses = [1, 2];
this.tasksStore = AspNetData.createStore({
key: "ID",
loadUrl: this.url + "/Tasks",
updateUrl: this.url + "/UpdateTask",
onBeforeSend: function(method, ajaxOptions) {
ajaxOptions.xhrFields = { withCredentials: true };
}
}),
this.dataSource = {
store: this.tasksStore,
reshapeOnPush: true
};
this.onAdd = this.onAdd.bind(this);
}
onAdd(e) {
var key = e.itemData.ID,
values = { Status: e.toData };
this.tasksStore.update(key, values).then(() => {
this.tasksStore.push([{
type: "update", key: key, data: values
}])
});
}
}
@NgModule({
imports: [
BrowserModule,
DxDataGridModule
],
declarations: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule { }
platformBrowserDynamic().bootstrapModule(AppModule);
.tables {
display: flex;
}
.column:first-child {
width: 50%;
padding-right: 15px;
}
.column:last-child {
width: 50%;
padding-left: 15px;
}
import { Injectable } from '@angular/core';
export class Priority {
id: number;
text: string;
}
let priorities: Priority[] = [{
id: 1, text: "Low"
}, {
id: 2, text: "Normal"
}, {
id: 3, text: "High"
}, {
id: 4, text: "Urgent"
}];
@Injectable()
export class Service {
getPriorities() {
return priorities;
}
}
// 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://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/
System.config({
transpiler: 'ts',
typescriptOptions: {
module: "system",
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': 'npm:@angular',
'tslib': 'npm:tslib/tslib.js',
'rxjs': 'npm:rxjs',
'devextreme-aspnet-data-nojquery': 'npm:devextreme-aspnet-data-nojquery@2.6.1',
'devextreme': 'npm:devextreme@20.1',
'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js',
'quill': 'npm:quill@1.3.7/dist/quill.js',
'devexpress-diagram': 'npm:devexpress-diagram@1.0.14',
'devexpress-gantt': 'npm:devexpress-gantt@1.0.7',
'devextreme-angular': 'npm:devextreme-angular@20.1'
},
packages: {
'app': {
main: './app.component.ts',
defaultExtension: 'ts'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
},
packageConfigPaths: [
"npm:*/package.json",
"npm:@angular/*/package.json",
"npm:@angular/common/*/package.json",
"npm:rxjs/operators/package.json",
"npm:devextreme-angular@20.1/*/package.json",
"npm:devextreme-angular@20.1/ui/*/package.json",
]
});
<!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/20.1.7/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.7/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.10.2/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>