JavaScript
$('#loadLink').on('click', loaddata);
var objColumns = [];
var myData;
// populate datagrid
function loaddata() {
$('#tt').datagrid({
data: myData,
nowrap : true,
fit : true,
fitColumns : true,
striped : true,
showFooter : true,
pagination : true,
rownumbers : true,
remoteSort : true,
autoRowHeight : true,
singleSelect : false,
ctrlSelect : false,
columns: [objColumns]
});
}
objColumns.push({ field: 'inv', width: 1, hidden: true, notRemove: true });
objColumns.push({ field: 'date', width: 120 , align: 'left', sortable: true, hidden: false });
objColumns.push({ field: 'note', width: 80, align: 'left', sortable: true, hidden: false });
objColumns.push({ field: 'price', width: 60 , align: 'left', sortable: true, hidden: false });
objColumns.push({ field: 'cost', width: 80 , align: 'left', sortable: true, hidden: false });
objColumns.push({ field: 'amount', width: 100, align: 'left', sortable: true, hidden: false });
myData = [{"inv":"INV0001","date":"2017-08-17","name":"Name1","note":"Note1 <img src='https://cdn.shopify.com/s/files/1/1061/1924/products/Sad_Face_Emoji_large.png' style='height:100px;'>","amount":86,"price":"122.88","cost":"10567.68"},{"inv":"INV0002","date":"2017-08-18","name":"Name2","note":"Note2","amount":73,"price":"168.78","cost":"12320.94"},{"inv":"INV0001","date":"2017-08-17","name":"Name1","note":"Note1 <img src='https://cdn.shopify.com/s/files/1/1061/1924/products/Sad_Face_Emoji_large.png' style='height:100px;'>","amount":86,"price":"122.88","cost":"10567.68"},{"inv":"INV0002","date":"2017-08-18","name":"Name2","note":"Note2","amount":73,"price":"168.78","cost":"12320.94"},{"inv":"INV0001","date":"2017-08-17","name":"Name1","note":"Note1 <img...