-- Learning not just technology, but dreams!
Home HTML JAVASCRIPT CSS VUE REACT PYTHON3 JAVA C C++ C# AI GO SQL LINUX VS CODE BOOTSTRAP GIT Local Bookmarks
jQuery EasyUI Tutorial
jQuery EasyUI Tutorial
jQuery EasyUI Introduction
jEasyUI Applications
jEasyUI Create CRUD Application
jEasyUI Create CRUD DataGrid
jEasyUI Form CRUD Application
jEasyUI Create RSS Reader
jEasyUI Drag and Drop
jEasyUI Basic Drag and Drop
jEasyUI Create Drag and Drop Shopping Cart
jEasyUI Create School Timetable
jEasyUI Menu and Button
jEasyUI Create Simple Menu
jEasyUI Create Link Button
jEasyUI Create Menu Button
jEasyUI Create Split Button
jEasyUI Layout
jEasyUI Create Border Layout
jEasyUI Create Complex Layout
jEasyUI Create Accordion
jEasyUI Create Tabs
jEasyUI Dynamically Add Tabs
jEasyUI Add Auto-play Tabs
jEasyUI Create XP-style Left Panel
jEasyUI DataGrid
jEasyUI Convert HTML Table to DataGrid
jEasyUI Get Selected Row Data
jEasyUI Add Search Function
jEasyUI Add Toolbar
jEasyUI Create Complex Toolbar
jEasyUI Set Frozen Columns
jEasyUI Dynamically Change Columns
jEasyUI Format Columns
jEasyUI Set Sorting
jEasyUI Custom Sorting
jEasyUI Create Column Groups
jEasyUI Add Checkboxes
jEasyUI Custom Pagination
jEasyUI Enable Row Editing
jEasyUI Extend Editors
jEasyUI Column Calculation
jEasyUI Merge Cells
jEasyUI Create Custom View
jEasyUI Create Footer Summary
jEasyUI Set Row Background Color Conditionally
jEasyUI Create PropertyGrid
jEasyUI Expand Row to Show Details
jEasyUI Create SubGrid
jEasyUI Display Massive Data
jEasyUI Add Pagination Component
jEasyUI Window
jEasyUI Create Simple Window
jEasyUI Custom Window Toolbar
jEasyUI Window and Layout
jEasyUI Create Dialog
jEasyUI Custom Dialog
jEasyUI Tree Menu
jEasyUI Create Tree Menu with Markup
jEasyUI Create Async Tree Menu
jEasyUI Add Nodes to Tree Menu
jEasyUI Create Tree Menu with Checkboxes
jEasyUI Tree Menu Drag and Drop Control
jEasyUI Tree Menu Load Parent/Child Nodes
jEasyUI Create Basic TreeGrid
jEasyUI Create Complex TreeGrid
jEasyUI TreeGrid Dynamic Loading
jEasyUI TreeGrid Add Pagination
jEasyUI TreeGrid Lazy Load Nodes
jEasyUI Form
jEasyUI Create Async Submit Form
jEasyUI Form Validation
jEasyUI Create Tree ComboBox
jEasyUI Format ComboBox
jEasyUI Filter DataGrid ComboBox
jEasyUI Reference Manual
jQuery EasyUI Plugins
jQuery EasyUI Extensions
jQuery EasyUI DataGrid β Extend Editors
jQuery EasyUI DataGrid β Merge Cells
Deep Dive
Programming
Web Design and Development
Software
Scripting Languages
Web Service
Web Services
Programming Languages
Computer Science
Development Tools
Scripts
jQuery EasyUI DataGrid - Column Calculation
In this tutorial, you will learn how to include a calculated column in an editable DataGrid. A calculated column typically contains values derived from one or more other columns.
First, create an editable DataGrid. Here we define some editable columns: 'listprice', 'amount', and 'unitcost' columns are defined with the numberbox editor type. The calculated column is the 'unitcost' field, which will be the result of multiplying the listprice by the amount column.
| Item ID |
List Price |
Amount |
Unit Cost |
Attribute |
Status |
When a user clicks a row, we initiate an editing action.
var lastIndex;
$('#tt').datagrid({
onClickRow:function(rowIndex){
if (lastIndex != rowIndex){
$('#tt').datagrid('endEdit', lastIndex);
$('#tt').datagrid('beginEdit', rowIndex);
setEditing(rowIndex);
}
lastIndex = rowIndex;
}
});
To create a calculation relationship between columns, we need to get the current editors and bind some events to them.
function setEditing(rowIndex){
var editors = $('#tt').datagrid('getEditors', rowIndex);
var priceEditor = editors;
var amountEditor = editors;
var costEditor = editors;
priceEditor.target.bind('change', function(){
calculate();
});
amountEditor.target.bind('change', function(){
calculate();
});
function calculate(){
var cost = priceEditor.target.val() * amountEditor.target.val();
$(costEditor.target).numberbox('setValue',cost);
}
}
Download jQuery EasyUI Example
jeasyui-datagrid-datagrid15.zip
jQuery EasyUI DataGrid β Extend Editors
jQuery EasyUI DataGrid β Merge Cells
ByteArk Coding Plan
Supports mainstream large models like Doubao, GLM, DeepSeek, Kimi, MiniMax, officially supplied, stable and reliable.
Configuration Guide
Β₯9.9
/ month
Activate Now
iFlytek Star Coding Plan
Includes free model call quota, DeepSeek, GLM, Kimi, MiniMax, one-stop experience and deployment platform.
Configuration Guide
Β₯3.9
/ month
Activate Now
Click to Share Notes
Category Navigation
Python / Data Science
AI / Intelligent Development
Front-end Development
Back-end Development
Database
Mobile Development
DevOps / Engineering
Programming Languages
Computer Fundamentals
XML / Web Service
.NET
Website Construction
Advertisement
jQuery EasyUI Tutorial
jQuery EasyUI Tutorial
jQuery EasyUI Introduction
jEasyUI Applications
jEasyUI Create CRUD Application
jEasyUI Create CRUD DataGrid
jEasyUI Form CRUD Application
jEasyUI Create RSS Reader
jEasyUI Drag and Drop
jEasyUI Basic Drag and Drop
jEasyUI Create Drag and Drop Shopping Cart
jEasyUI Create School Timetable
jEasyUI Menu and Button
jEasyUI Create Simple Menu
jEasyUI Create Link Button
jEasyUI Create Menu Button
jEasyUI Create Split Button
jEasyUI Layout
jEasyUI Create Border Layout
jEasyUI Create Complex Layout
jEasyUI Create Accordion
jEasyUI Create Tabs
jEasyUI Dynamically Add Tabs
jEasyUI Add Auto-play Tabs
jEasyUI Create XP-style Left Panel
jEasyUI DataGrid
jEasyUI Convert HTML Table to DataGrid
jEasyUI Get Selected Row Data
jEasyUI Add Search Function
jEasyUI Add Toolbar
jEasyUI Create Complex Toolbar
jEasyUI Set Frozen Columns
jEasyUI Dynamically Change Columns
jEasyUI Format Columns
jEasyUI Set Sorting
jEasyUI Custom Sorting
jEasyUI Create Column Groups
jEasyUI Add Checkboxes
jEasyUI Custom Pagination
jEasyUI Enable Row Editing
jEasyUI Extend Editors
jEasyUI Column Calculation
jEasyUI Merge Cells
jEasyUI Create Custom View
jEasyUI Create Footer Summary
jEasyUI Set Row Background Color Conditionally
jEasyUI Create PropertyGrid
jEasyUI Expand Row to Show Details
jEasyUI Create SubGrid
jEasyUI Display Massive Data
jEasyUI Add Pagination Component
jEasyUI Window
jEasyUI Create Simple Window
jEasyUI Custom Window Toolbar
jEasyUI Window and Layout
jEasyUI Create Dialog
jEasyUI Custom Dialog
jEasyUI Tree Menu
jEasyUI Create Tree Menu with Markup
jEasyUI Create Async Tree Menu
jEasyUI Add Nodes to Tree Menu
jEasyUI Create Tree Menu with Checkboxes
jEasyUI Tree Menu Drag and Drop Control
jEasyUI Tree Menu Load Parent/Child Nodes
jEasyUI Create Basic TreeGrid
jEasyUI Create Complex TreeGrid
jEasyUI TreeGrid Dynamic Loading
jEasyUI TreeGrid Add Pagination
jEasyUI TreeGrid Lazy Load Nodes
jEasyUI Form
jEasyUI Create Async Submit Form
jEasyUI Form Validation
jEasyUI Create Tree ComboBox
jEasyUI Format ComboBox
jEasyUI Filter DataGrid ComboBox
jEasyUI Reference Manual
jQuery EasyUI Plugins
jQuery EasyUI Extensions
Online Examples
Β·HTML Examples
Β·CSS Examples
Β·JavaScript Examples
Β·Ajax Examples
Β·jQuery Examples
Β·XML Examples
Β·Java Examples
Character Sets & Tools
Β· HTML Character Set Settings
Β· HTML ASCII Character Set
Β· JS Obfuscation/Encryption
Β· PNG/JPEG Image Compression
Β· HTML Color Picker
Β· JSON Formatting Tool
Β· Random Number Generator
Latest Updates
Β· Large Model Multimodal (M...
Β· Codex Advanced Configuration
Β· AI Agent Terminology
Β· ZCode Getting Started Tutorial
Β· Loop Engineerin...
Β· Claude Code Us...
Β· Claude Code Us...
Site Information
Β· Feedback
Β· Disclaimer
Β· About Us
Β· Article Archive
Follow WeChat
My Favorites
Mark Article
Browsing History
Clear All
No Records