Demo - Arrays and CollectionViews
HTML
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.latest/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.input.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.filter.min.js"></script>
<div class="container">
<div id="theGrid" style="height:300px;"></div>
</div>
JavaScript
onload = function() {
// create some random data
var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(',');
var data = [];
for (var i = 0; i < 1000; i++) {
data.push({
id: i,
country: countries[i%countries.length],
sales: Math.random() * 10000,
expenses: Math.random() * 5000
});
}
var cvData=new wijmo.collections.CollectionView(data,{
pageSize:10
})
// bind a grid to the raw data
var theGrid = new wijmo.grid.FlexGrid('#theGrid', {
allowSorting: false,
showSort: false,
autoGenerateColumns: false,
columns: [
{binding:'id'},
{ binding: 'country', header: 'Country', width: '2*'},
{ binding: 'sales', header: 'Sales', width: '*', format: 'n2'},
{ binding: 'expenses', header: 'Expenses', width: '*', format: 'n2'}
],
itemsSource: cvData
});
var filter=new wijmo.grid.filter.FlexGridFilter(theGrid);
filter.getColumnFilter("id").valueFilter.maxValues=1000;
}