Data binding

The Grid control uses ej.DataManager which supports both RESTful JSON data services binding and local JSON array binding. The dataSource property can be assigned either with the instance of ej.DataManger or JSON data array collection. It supports different kinds of data binding methods such as

  1. Local data
  2. Remote data

Local Data

To bind local data to the Grid, you can assign a JSON array to the dataSource property.

The following code example describes the above behavior.

  • html
  • <div id="Grid"></div>
  • ts
  • /// <reference path="tsfiles/jquery.d.ts" />
    /// <reference path="tsfiles/ej.web.all.d.ts" />
    
    module GridComponent {
        $(function () {
            var gridInstance = new ej.Grid($("#Grid"), {
                //The datasource "window['gridData'] is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                dataSource: window["gridData"],
                allowPaging: true,
    			columns: ["OrderID", "EmployeeID", "ShipCity", "ShipCountry", "Freight"]   
          });
        });
    }

    The following output is displayed as a result of the above code example.

    NOTE

    1. There is no in-built support to bind the XML data to the grid. But you can achieve this requirement with the help of custom adaptor concept.
    2. Refer this Knowledge Base link for bounding XML data to grid using custom adaptor.

    Remote Data

    To bind remote data to Grid Control, you can assign a service data as an instance of ej.DataManager to the dataSource property.

    OData

    OData is a standardized protocol for creating and consuming data. You can provide the OData service URL directly to the ej.DataManager class and then you can assign it to Grid dataSource.

    The following code example describes the above behavior.

  • html
  • <div id="Grid"></div>
  • ts
  • /// <reference path="tsfiles/jquery.d.ts" />
    /// <reference path="tsfiles/ej.web.all.d.ts" />
    
    module GridComponent {
        $(function () {
            var dataManager = new ej.DataManager("http://js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Orders/");
            var gridInstance = new ej.Grid($("#Grid"), {
                dataSource: dataManager,
    			allowPaging:true,
    			columns: ["OrderID", "EmployeeID", "CustomerID", "ShipCountry", "Freight"]
          });
        });
    }

    The following output is displayed as a result of the above code example.

    NOTE

    By default, if no adaptor is specified for ej.DataManager and only the url link is mentioned it will consider as ODataService.