jQuery Grid

Set the deferreddatafields property of the jqxGrid. Author: http://jqwidgets.com

by CHIU SHIH-WEI

HTML

<script src="http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/generatedata.js"></script>
<link rel="stylesheet" href="http://jqwidgets.com/public/jqwidgets/styles/jqx.base.css">
<link rel="stylesheet" href="http://jqwidgets.com/public/jqwidgets/styles/jqx.energyblue.css">
<script src="http://jqwidgets.com/public/jqwidgets/jqx-all.js"></script>
<div id="jqxgrid"></div>

JavaScript

var data = generatedata(2500);
 var source = {
     localdata: data,
     datafields: [
          {
         name: 'quantity',
         type: 'number'
     }, {
         name: 'price',
         type: 'number'
     }, {
         name: 'total',
         type: 'number'
     }],
     datatype: "array"
 };
 var adapter = new $.jqx.dataAdapter(source);
 $("#jqxgrid").jqxGrid({
     width: 500,
     theme: 'energyblue',
     source: adapter,
     scrollmode: 'deferred',
        editable: true,
                enabletooltips: true,
     deferreddatafields: ['firstname', 'lastname', 'productname'],
     columns: [
        {
         text: 'Quantity',
         datafield: 'quantity',
       align: 'right', cellsalign: 'right', cellsformat: 'c2', columntype: 'numberinput',  createeditor: function (row, cellvalue, editor) {
                          editor.jqxNumberInput({ digits: 3 });
         }, aggregates: ['sum']
                  }, {
         text: 'Unit Price',
         datafield: 'price',
          align: 'right', cellsalign: 'right', cellsformat: 'c2', columntype: 'numberinput',  createeditor: function (row, cellvalue, editor) {
                          editor.jqxNumberInput({ digits: 3 });
         }, aggregates: ['sum']
                  }, {
         text: 'Total',
         datafield: 'total',
           align: 'right', cellsalign: 'right', cellsformat: 'c2', columntype: 'numberinput',  createeditor: function (row, cellvalue, editor) {
                          editor.jqxNumberInput({ digits: 3 });
         }, aggregates: ['sum']
                  }]
 });