Html Grid

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

by Brandi McGahee

HTML

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

<div id="jqxgrid"></div>

JavaScript

var data = generatedata(500);
 var source = {
   localdata: data,
   datafields: [{
     name: 'firstname',
     type: 'string'
   }, {
     name: 'lastname',
     type: 'string'
   }, {
     name: 'productname',
     type: 'string'
   }, {
     name: 'date',
     type: 'date'
   }, {
     name: 'quantity',
     type: 'number'
   }, {
     name: 'price',
     type: 'number'
   }],
   datatype: "array"
 };

 var adapter = new $.jqx.dataAdapter(source);

 var firstNameColumnFilter = function() {
   var filtergroup = new $.jqx.filter();

   var filter_or_operator = 1;
   var filtervalue = 'Nancy';
   var filtercondition = 'contains';
   var filter = filtergroup.createfilter('stringfilter', filtervalue, filtercondition);

   filtergroup.addfilter(filter_or_operator, filter);
   return filtergroup;
 }();

 $("#jqxgrid").jqxGrid({
   width: 850,
   source: adapter,
   filterable: true,
   showfilterrow: true,
   sortable: true,
   columns: [{
     text: 'First Name',
     datafield: 'firstname',
     filter: firstNameColumnFilter,
     filtertype: 'checkedlist',
     width: 160
   }, {
     text: 'Last Name',
     datafield: 'lastname',
     width: 160
   }, {
     text: 'Product',
     datafield: 'productname',
     width: 170
   }, {
     text: 'Order Date',
     datafield: 'date',
     filtertype: 'date',
     width: 160,
     cellsformat: 'dd-MMMM-yyyy'
   }, {
     text: 'Quantity',
     datafield: 'quantity',
     width: 80,
     cellsalign: 'right'
   }, {
     text: 'Unit Price',
     datafield: 'price',
     cellsalign: 'right',
     cellsformat: 'c2'
   }]
 });