How to

20 Jul 201824 minutes to read

Binding SignalR endpoint

Grid supports SignalR features for live updates in record. Please find the below option to configure signalR with Grid.

1) Before configure SignalR with ejGrid. You need to Setup SignalR configuration in Visual Studio project. For reference, please find the link.

NOTE

Getting started with SignalR

2) After configuration of SignalR, you have to create Hub for communication between different actions of grid.

  • C#
  • public class SignalHub: Hub
    
    {
    
    	public void modify(string action, string details)
    
    	{
    
    		Clients.All.modify(action, details);
    
    	}
    
    }

    3) Implementation of SignalR communication with Grid through Hub.

  • HTML
  • <ej-grid id="Grid" #grid [dataSource]="gridData" [editSettings]="editSettings" [toolbarSettings]="toolbarSettings" [allowPaging]=true [allowSorting]=true (actionComplete)="actionComplete($event)">
        <e-columns>
            <e-column field="OrderID" [isPrimaryKey]="true" headerText="Order ID" width="75" textAlign="right"></e-column>
            <e-column field="CustomerID" headerText= 'Customer ID' width= "80"></e-column>
            <e-column field="EmployeeID" headerText='Employee ID' textAlign="right" width="75"></e-column>
            <e-column field="Freight" textAlign="right" width="75" format= "{0:C}" ></e-column>
            <e-column field="ShipCity" headerText='Ship City' width="110"  ></e-column>
        </e-columns>
    </ej-grid>
  • TS
  • import {Component, ViewEncapsulation, ViewChild } from '@angular/core';
        @Component({
          selector: 'ej-app',
          templateUrl: 'app/app.component.html',  //give the path file for Grid control html file.
        })
        export class AppComponent {
            public gridData;
            public editSettings;
            public toolbarSettings;
            @ViewChild("grid") gridIns: EJComponents<any, any>;  
        	constructor()
            {
                //The datasource "(window as any).gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                this.gridData = ej.DataManager((window as any).gridData).executeLocal(ej.Query().take(50));
                this.editSettings={allowAdding: true, allowEditing: true, allowDeleting: true };
                this.toolbarSettings={showToolbar: true, toolbarItems: [ej.Grid.ToolBarItems.Add, ej.Grid.ToolBarItems.Edit, ej.Grid.ToolBarItems.Delete, ej.Grid.ToolBarItems.Update, ej.Grid.ToolBarItems.Cancel]};
            }
            
         }
  • JAVASCRIPT
  • window.signal = $.connection.signalHub;
            window.signal.client.modify = function (action, details) {
              details = JSON.parse(details);
              if (action == "add") this.gridIns.widget.addRecord(details);
              else if (action == "beginedit") this.gridIns.widget.updateRecord("OrderID", details);
              else this.gridIns.widget.deleteRecord("OrderID", details);
            };
            $.connection.hub.start().done(function () {
              window.actionComplete = function (args) {
                  if (args.requestType == "save" || args.requestType == "delete") window.signal.server.modify(args.requestType == "delete" ? args.requestType : window.previousAction, JSON.stringify(args.rowData));
                  if (args.requestType != "delete") window.previousAction = args.requestType;
              }
            });

    Copy data from Excel to Grid

    Copy data from Excel to Grid is possible by converting Excel data to JSON data and then binding it to the Grid. Details are covered in this blog post.

    Prevent/Maintain persistence of properties

    Grid actions can be persisted throughout by enabling the enablePersistence property of the Grid. However, we can maintain/prevent a grid action explicitly with the help of addToPersist and ignoreOnPersist methods respectively.

  • HTML
  • <a href="http://www.syncfusion.com">Navigate to another Page</a>
        <ej-button id="Button" (click)="onClick($event)" text="Prevent/Maintain persistence"></ej-button>
        <ej-grid id="Grid" #grid [dataSource]="gridData" [allowFiltering]="true" [filterSettings]="filterSettings" [allowPaging]=true [allowGrouping]=true [enablePersistence]=true>
            <e-columns>
                <e-column field="OrderID" headerText="Order ID" width="75" textAlign="right"></e-column>
                <e-column field="CustomerID" headerText= 'Customer ID' width= "80"></e-column>
                <e-column field="EmployeeID" headerText='Employee ID' textAlign="right" width="75"></e-column>
                <e-column field="Freight" textAlign="right" width="75" format= "{0:C}" ></e-column>
            </e-columns>
        </ej-grid>
  • TS
  • import {Component, ViewEncapsulation, ViewChild } from '@angular/core';
        @Component({
          selector: 'ej-app',
          templateUrl: 'app/app.component.html',  //give the path file for Grid control html file.
        })
        export class AppComponent {
            public gridData;
            public filterSettings;
            @ViewChild("grid") gridIns: EJComponents<any, any>;  
        	constructor()
            {
                //The datasource "(window as any).gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                this.gridData = (window as any).gridData;
                this.filterSettings={filterType: "menu"};
            }
            onClick(e:any){
                var gridObj = this.gridIns.widget;//get the gridObject
                // by default the enableAltRow property of the grid is true.
                gridObj.option("model.enableAltRow", false);   //set the enableAltRow property of the grid as false 
                //by default the filterSettings and groupSettings will be persisted upon navigating to another page.
                gridObj.ignoreOnPersist(["filterSettings", "groupSettings"]);// set the properties that are to be prevented from being persisted
                //by default the enableAltRow property of the grid will not be persisted
                gridObj.addToPersist("enableAltRow");// set the properties that are to be maintained for persistence.
                var toolbarObject = $(e.target),
                grid = this.gridIns.widget;
                if (toolbarObject.hasClass("Collapse")) grid.collapseAll(); //collapse Grid using grid instance, `this` is grid instance
                else grid.refreshContent(); //refresh content using grid instance
            }
         }

    So on navigating to another page by clicking on the link, by default the filterSettings and groupSettings will be persisted. But upon clicking the button and navigating, the persist state of the Grid actions are modified.

    External Search in Grid

    Using search method of Grid, you can search the string in Grid externally without using in-built toolbar search support. While using search method it is necessary to set allowSearching property as true. The following code example explains the above behavior.

  • HTML
  • <input type="text" id="searchString" class="e-ejinputtext" />
        <ej-button id="Button" (click)="onClick($event)" text="Searching"></ej-button>
        <ej-grid id="Grid" #grid [dataSource]="gridData" [allowSearching]="true" [filterSettings]="filterSettings" [allowPaging]=true [allowGrouping]=true [enablePersistence]=true>
            <e-columns>
                <e-column field="OrderID"></e-column>
                <e-column field="CustomerID"></e-column>
                <e-column field="EmployeeID"></e-column>
                <e-column field="Freight"></e-column>
                <e-column field="ShipCity"></e-column>
                <e-column field="ShipCountry"></e-column>
            </e-columns>
        </ej-grid>
  • TS
  • import {Component, ViewEncapsulation, ViewChild } from '@angular/core';
        @Component({
          selector: 'ej-app',
          templateUrl: 'app/app.component.html',  //give the path file for Grid control html file.
        })
        export class AppComponent {
            public gridData;
            @ViewChild("grid") gridIns: EJComponents<any, any>;  
        	constructor()
            {
                //The datasource "(window as any).gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                this.gridData = (window as any).gridData;
                
            }
            onClick(e:any){
                var obj = this.gridIns.widget;//get the gridObject
                var val = $("#searchString").val();
                obj.search(val);
            }
         }

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

    Hierarchy Grid with different foreignKeyField in parent and child table

    The queryString property is used to filter the childGrid data based on value in parent Grid data. But when the field name provided in queryString does not exists in Child Grid, then foreignKeyField property is used to filter the childGrid data. If the foreign key column name differs for parent and child grid then use foreignKeyField property of Grid.

    The following code example explains the above behavior.

  • HTML
  • <ej-grid id="Grid"  [allowPaging]="true"  [dataSource]="gridData"  [childGrid]="childData"  >
        <e-columns>
            <e-column field="EmployeeID" headerText="Employee ID"  width="85" textAlign="right"></e-column>
            <e-column field="FirstName" headerText="First Name" textAlign="left"  width="100"></e-column>    
            <e-column field="City" headerText="City" textAlign="left" width="10"></e-column> 
            <e-column field="Country" headerText="Country" textAlign="left" width="100"></e-column>        
        </e-columns>
    </ej-grid>
  • JAVASCRIPT
  • import { Component } from '@angular/core';
    
    
    @Component({
        selector: 'ej-app',
        templateUrl: 'src/grid/grid.component.html',
    })
    export class GridComponent {
        public gridData: any;
        public childData: any;    
        constructor() {
    
            //The datasource "window.employeeView" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
            this.gridData = (window as any).employeeView;
            this.childData = {
    
                dataSource: ej.DataManager({ url: " http://js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Orders", crossDomain: true }),
                queryString: "FirstName",
                foreignKeyField : "CustomerName",
                allowPaging: true,
                pageSettings: {
                    pageSize: 5
                }, columns: [
                    { field: "OrderID", headerText: 'Order ID', textAlign: ej.TextAlign.Right, width: 75 },
                    { field: "ShipCity", headerText: 'Ship City', textAlign: ej.TextAlign.Left, width: 100 },
                    { field: "CustomerName", headerText: 'First Name', textAlign: ej.TextAlign.Left, width: 100 },
                    { field: "CustomerID", headerText: 'Customer ID', textAlign: ej.TextAlign.Left, width: 120 },
                    { field: "ShipName", headerText: 'Ship Name', textAlign: ej.TextAlign.Left, width: 100 }
                ],
    
            }
        }
    }

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

    Perform Grid Actions on External button click

    CRUD operations

    Using addRecord method of Grid, you can add a record to a Grid externally without using in-built toolbar add support. While using addRecord method it is necessary to set allowAdding property as true.
    Using deleteRecord method of Grid, you can delete a record to a Grid externally without using in-built toolbar delete support. While using deleteRecord method it is necessary to set allowDeleting property as true.
    Using updateRecord method of Grid, you can update a record to a Grid externally without using in-built toolbar update support. While using updateRecord method it is necessary to set allowEditing property as true.

    Filtering

    Using filterColumn method of Grid, you can filter the data in the Grid externally without using in-built filter support. While using filterColumn method it is necessary to set allowFiltering property as true.

    Grouping

    Using groupColumn and ungroupColumn method of Grid, you can group/ungroup the Grid externally without using in-built grouping support. While using groupColumn and ungroupColumn method it is necessary to set allowGrouping property as true.

    Sorting

    Using sortColumn method of Grid, you can sort the Grid externally without using in-built sorting support. While using sortColumn method it is necessary to set allowSorting property as true.

    The following code example explains the above behavior.

    <table>
        <tr>
            <td><b>CRUD</b><br><input type="button" ej-button id="Addrecord" text="Addrecord" (click)="addRecord($event)"/>
                                <input type="button" ej-button id="Updaterecord" text="Updaterecord" (click)="updateRecord($event)"/>
                                <input type="button" ej-button id="DeleteRecord" text="DeleteRecord" (click)="deleteRecord($event)"/></td>
            <td><b>Filtering</b><br><br><input type="text" id="filterone" /><input type="text" id="filtertwo" /><input type="button" ej-button id="filteri" text="Filter" (click)="FilterFunction($event)"/><input type="button" ej-button id="ClearFilter" text="Clear" (click)="clearfilterfn($event)"/></td>
            <input id="filterColumnOne" ej-dropdownlist [watermarkText]="waterMarkOne" [targetID]="OrderList"/><div id="Order"><ul><li>10248</li><li>10249</li><li>10250</li><li>10251</li><li>10252</li></ul></div>
            <input id="filterColumnTwo" ej-dropdownlist [watermarkText]="waterMarkTwo" [targetID]="EmployeeList"/><div id="Employee"><ul><li>1</li><li>2</li><li>3</li><li>4</li><li>5</li></ul></div>
            <td><b>Grouping</b><br><br>
                <input id="groupColumnName" ej-dropdownlist [targetID]="columnNameList" [selectedIndex]="index"/><div id="columnName"><ul><li>OrderID</li><li>CustomerID</li><li>Freight</li><li>Verified</li><li>ShipName</li></ul></div><br>
                <input type="button" ej-button id="groupColumn" text="GroupColumn" (click)="clickToGroup($event)"/>
                <input type="button" ej-button id="unGroupColumn" text="UnGroupColumn" (click)="clickToGroup($event)"/>
            </td>
            <td><b>Sorting</b><br><br>
                <input id="SortColumnName" ej-dropdownlist [targetID]="sortcolumnNameList" [selectedIndex]="index"/><div id="sortcolumnName"><ul><li>Order ID</li><li>Customer ID</li><li>Employee ID</li><li>Freight</li><li>Ship City</li></ul></div>
                <input id="Directions" ej-dropdownlist [targetID]="directionsList" [selectedIndex]="index"/><div id="directions"><ul><li>Ascending</li><li>Descending</li></ul></div>
                <input type="button" ej-button id="doSorting" text="Sort" (click)="SortFunction($event)"/>
                <input type="button" ej-button id="clearSort" text="Clear" (click)="clearSortFunction($event)"/>
            </td>
        </tr>
    </table>
    <ej-grid #Grid [dataSource]="gridData" [allowPaging]="true" [allowSorting]="true" [allowFiltering]="true" [allowGrouping]="true" [editSettings]="editSettings" [toolbarSettings]="toolbarSettings">
        <e-columns>
            <e-column field= "OrderID" [isPrimaryKey]="true" headerText="Order ID"></e-column>
            <e-column field= "CustomerID" headerText="Customer ID"></e-column>
            <e-column field= "EmployeeID" headerText="Employee ID"></e-column>
            <e-column field= "Freight"></e-column>
            <e-column field= "OrderDate" headerText="Order Date"></e-column>
        </e-columns>
    </ej-grid>
    import {Component, ViewEncapsulation, ViewChild } from '@angular/core';
        @Component({
          selector: 'ej-app',
          templateUrl: 'app/app.component.html',  //give the path file for Grid control html file.
        })
        export class AppComponent {
            public gridData;
            @ViewChild("grid") gridIns: EJComponents<any, any>;  
            editSettings:any;
            directionsList:any;
            sortColumnNameList:any;
            columnNameList:any;
            waterMarkOne:string;
            waterMarkTwo:string;
            EmployeeList:any;
            index:number;
            OrderList:any;
            toolbarSettings:any;
        	constructor()
            {
                //The datasource "(window as any).gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                this.gridData = (window as any).gridData;
                this.editSettings={allowEditing:true,allowAdding:true,allowDeleting:true };
                this.toolbarSettings={ showToolbar: true,toolbarItems: ["add","edit","update","cancel"]};
                this.directionsList="directions";
                this.sortColumnNameList="sortColumnName";
                this.columnNameList="columnName";
                this.EmployeeList="Employee";
                this.OrderList="Order";
                this.waterMarkOne="Select filter value one";
                this.waterMarkTwo="Select filter value two";
                this.index=0;
             }
             addRecord() {
                this.Grid.widget.addRecord({"OrderID":12333});
             }
             updateRecord() {
                this.Grid.widget.updateRecord("OrderID", { OrderID: 10248, EmployeeID: 1});
             }
             deleteRecord() {
                this.Grid.widget.deleteRecord("OrderID", { OrderID: this.Grid.widget.model.dataSource_two[this.Grid.widget.model.selectedRowIndex].OrderID });
             }
             FilterFunction(args) {
                var obj = $('#FlatGrid').data("ejGrid");
                var one = $('#filterColumnOne').data("ejDropDownList");
                var two = $('#filterColumnTwo').data("ejDropDownList");
                var One = one.getValue();
                var Two = two.getValue();
                this.Grid.widget.filterColumn([{field:"OrderID",operator:"equal",value:One,predicate:"and", matchcase:true},{field:"EmployeeID",operator:"equal",value:Two,predicate:"and", matchcase:true}]);
             }
             clearFilterFunction(args) {
                this.Grid.widget.clearFiltering();
             }
             clearSortFunction(args) {
                            this.Grid.widget.clearSorting();
             }
             SortFunction(args) {
                    var sortDo = $('#doSorting').data("ejButton");
                    if (sortDo._id == "doSorting") {
                        var name = $('#SortColumnName').data("ejDropDownList");
                    var direction = $('#Directions').data("ejDropDownList");
                    var columnName = name.getValue().replace(/\s*/g, "");
                    var sortDirection = direction.getValue().toLowerCase();
                    this.Grid.widget.sortColumn(columnName, sortDirection);
                }
             }
             clickToGroup(args) {
                var columnName = $("#groupColumnName").ejDropDownList("getSelectedValue");
                if (args.srcElement.id == "groupColumn") {
                    this.Grid.widget.groupColumn(columnName);
                        $("#groupColumn").ejButton("disable");
                        $("#unGroupColumn").ejButton("enable");
                    
                }
                else {
                    this.Grid.widget.ungroupColumn(columnName);
                    $("#unGroupColumn").ejButton("disable");
                    $("#groupColumn").ejButton("enable");
                }
             }
             OnChange() {
                var columnName = $("#groupColumnName").ejDropDownList("getSelectedValue");
                if ($.inArray(columnName, this.Grid.widget.model.groupSettings.groupedColumns) != -1) {
                    $("#unGroupColumn").ejButton("enable");
                    $("#groupColumn").ejButton("disable");
                }
                else {
                    $("#groupColumn").ejButton("enable");
                    $("#unGroupColumn").ejButton("disable");
                }
             }
        }

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

    Display other Syncfusion controls in Grid columns

    We can display the other Syncfusion controls using ng-template with e-template attribute directive in Grid columns.

  • HTML
  • <ej-grid #grid [(dataSource)]="gridData" [allowPaging]="true" >
        <e-columns>
            <e-column headerText="Employee Rating" width="150">
                <ng-template e-template let-data>
                    <ej-rating id="rating" [value]="data.EmployeeID" [allowReset]="true"></ej-rating>
                </ng-template>
            </e-column>
            <e-column field="EmployeeID" [isPrimaryKey]="true" headerText="Employee ID"  width="90"></e-column>
            <e-column field="FirstName"  headerText="First Name" width="90"></e-column>
            <e-column field="LastName" headerText="Last Name" width="90" ></e-column>
            <e-column field="Country" headerText="Country" width="80" ></e-column>
        </e-columns>     
    </ej-grid>
  • TS
  • import {Component, ViewEncapsulation, ViewChild } from '@angular/core';
        @Component({
          selector: 'ej-app',
          templateUrl: 'app/app.component.html',  //give the path file for Grid control html file.
        })
        export class AppComponent {
            public gridData;
            @ViewChild("grid") gridIns: EJComponents<any, any>;  
        	constructor()
            {
                //The datasource "(window as any).gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
                this.gridData = (window as any).employeeView;
                
            }
         }

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

    Getting Datasource of Grid in Sorted Order

    Grid column can be sorted and after sorting, the datasource can be obtained in the same order using sortBy query and executeLocal method of DataManager.

    The following code example describes the above behavior.

    <input type="button" ej-button id="button1" value="GetSortedData" (ejclick)="GetSortedData($event)" />
    
    <ej-grid #grid  [dataSource]="gridData" [allowPaging]="true" [allowSorting]="true" [allowMultiSorting]="true">
          
      <e-columns>     
          <e-column field="OrderID" headerText="OrderID" width="75" textAlign="right"></e-column>
          <e-column field="EmployeeID" headerText="EmployeeID" width="90" textAlign="right"></e-column>
          <e-column field="CustomerID" headerText="CustomerID" width="90" textAlign="right"></e-column>
      </e-columns>  
    
    </ej-grid>
    import {Component, ViewEncapsulation,ViewChild} from '@angular/core';
    
    import {CommonModule} from "@angular/common";
    
    @Component({
        selector: 'ej-app',
        templateUrl: 'src/grid/grid.component.html',
    })
    export class GridComponent {
        public gridData;
        constructor()
        {
           //The datasource "window.gridData" is referred from 'http://js.syncfusion.com/demos/web/scripts/jsondata.min.js'
           this.gridData = window.gridData;
                
        }
    
        GetSortedData(e: any){
                var obj = $(".e-grid").ejGrid("instance");   
                var Sort = obj.model.sortSettings.sortedColumns;  
                var query = ej.Query();               
                if(obj.model.sortSettings.sortedColumns.length){
                    for(var i=Sort.length-1;i>=0;i--){        
                      query.sortBy(Sort[i].field, Sort[i].direction); 
                    }
                var SortedDatasource = ej.DataManager(obj.model.dataSource()).executeLocal(query); 
                      console.log(SortedDatasource); 
                }
            }
    }

    NOTE

    This solution will work only for local data.