Enable DataGrid Inline Editing

Tutorial » Enable DataGrid Inline Editing

The editable feature was recently added to the datagrid. It enable the user to add a new row to the datagrid. The user may also update one or more rows.

This tutorial shows how to create a datagrid with inline editing.

View Demo

Create DataGrid

$(function(){
		$('#tt').datagrid({
			title:'Editable DataGrid',
			iconCls:'icon-edit',
			width:660,
			height:250,
			singleSelect:true,
			idField:'itemid',
			url:'data/datagrid_data.json',
			columns:[[
				{field:'itemid',title:'Item ID',width:60},
				{field:'productid',title:'Product',width:100,
					formatter:function(value,row){
						return row.productname || value;
					},
					editor:{
						type:'combobox',
						options:{
							valueField:'productid',
							textField:'name',
							data:products,
							required:true
						}
					}
				},
				{field:'listprice',title:'List Price',width:80,align:'right',editor:{type:'numberbox',options:{precision:1}}},
				{field:'unitcost',title:'Unit Cost',width:80,align:'right',editor:'numberbox'},
				{field:'attr1',title:'Attribute',width:180,editor:'text'},
				{field:'status',title:'Status',width:50,align:'center',
					editor:{
						type:'checkbox',
						options:{
							on: 'P',
							off: ''
						}
					}
				},
				{field:'action',title:'Action',width:80,align:'center',
					formatter:function(value,row,index){
						if (row.editing){
							var s = '<a href="javascript:void(0)" onclick="saverow(this)">Save</a> ';
							var c = '<a href="javascript:void(0)" onclick="cancelrow(this)">Cancel</a>';
							return s+c;
						} else {
							var e = '<a href="javascript:void(0)" onclick="editrow(this)">Edit</a> ';
							var d = '<a href="javascript:void(0)" onclick="deleterow(this)">Delete</a>';
							return e+d;
						}
					}
				}
			]],
			onEndEdit:function(index,row){
				var ed = $(this).datagrid('getEditor', {
					index: index,
					field: 'productid'
				});
				row.productname = $(ed.target).combobox('getText');
			},
			onBeforeEdit:function(index,row){
				row.editing = true;
				$(this).datagrid('refreshRow', index);
			},
			onAfterEdit:function(index,row){
				row.editing = false;
				$(this).datagrid('refreshRow', index);
			},
			onCancelEdit:function(index,row){
				row.editing = false;
				$(this).datagrid('refreshRow', index);
			}
		});
	});

To enable editing in datagrid, you should add a editor property to the columns. The editor tells datagrid how to edit the field and how to save the field value. As you can see we define three editor:text,combobox and checkbox.

Download the EasyUI example:

easyui-datagrid-demo.zip