Build CRUD DataGrid with jQuery EasyUI

Tutorial » Build CRUD DataGrid with jQuery EasyUI

In the previous tutorial we create a crud application that using dialog component to create or edit user information. This tutorial will show you how to create a crud datagrid. We will use the editable datagrid plugin to make these crud actions work.

View Demo

Step 1: Define DataGrid in HTML tag

<table id="dg" title="My Users" style="width:550px;height:250px"
		toolbar="#toolbar" idField="id"
		rownumbers="true" fitColumns="true" singleSelect="true">
	<thead>
		<tr>
			<th field="firstname" width="50" editor="{type:'validatebox',options:{required:true}}">First Name</th>
			<th field="lastname" width="50" editor="{type:'validatebox',options:{required:true}}">Last Name</th>
			<th field="phone" width="50" editor="text">Phone</th>
			<th field="email" width="50" editor="{type:'validatebox',options:{validType:'email'}}">Email</th>
		</tr>
	</thead>
</table>
<div id="toolbar">
	<a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" onclick="javascript:$('#dg').edatagrid('addRow')">New</a>
	<a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onclick="javascript:$('#dg').edatagrid('destroyRow')">Destroy</a>
	<a href="#" class="easyui-linkbutton" iconCls="icon-save" plain="true" onclick="javascript:$('#dg').edatagrid('saveRow')">Save</a>
	<a href="#" class="easyui-linkbutton" iconCls="icon-undo" plain="true" onclick="javascript:$('#dg').edatagrid('cancelRow')">Cancel</a>
</div>

Step 2: Make an editable DataGrid

We should provide the 'url','saveUrl','updateUrl' and 'destroyUrl' properties for editable datagrid:

url: to retrieve user data from server.
saveUrl: to save a new user data.
updateUrl: to update an exists user data.
destroyUrl: to destroy an exists user data.

Step 3: Write server processing code

Save a new user(save_user.php):

Update an exists user(update_user.php):

Destroy an exists user(destroy_user.php):

Download the EasyUI example:

easyui-crud-demo.zip