About hierarchical bindings of grid

[Pylori]

Hi,

Is it possible to do hierarchical binding easily without using "QueryString" for parent-child relationship view models as follows?

class ParentViewModel

{

    public string ParentName { get; set; }

    public List<ChildViewModel> Children { get; set; }

}

class ChildViewModel

{

    public string ChildName { get; set; }

}

Regards,
Pylori.

[Pavithra Subramaniyam]

Hi Pylori, 

 

Thanks for contacting Syncfusion support.  

 

Query : Is it possible to do hierarchical binding easily without using "QueryString" for parent-child relationship view models as follows? 

 

No, The child Grid is bounded to the Parent row based on the “queryString” relation only. So defining the ‘queryString’ property is essential for the Hierarchical Binding feature. 

 

Regards, 

Pavithra S. 

[Pylori]

Hi Pavithra S,

Thank you for answering.

Implement using "QueryString".

Regards,

Pylori.

[Pavithra Subramaniyam]

Hi Pylori, 

 

Thanks for the update. 

 

We would like to explain the “Hierarchical binding in Grid”. The Grid will display as a hierarchy(parent-child) when the dataSource of the parent and child Grid have a common “field” name(which will be used as the value for “QueryString”), and by comparing the values of this field name, the child Grid will be displayed.  

 

Based on the shared model, we have prepared a sample by binding same dataSource for both child and parent Grids. We have achieved this requirement by using the “created” event of Child Grid. Please refer the code example and sample link below, 

 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/gridmvclocalization-2016728499 

 

[Index.cshtml] 

 

<div> 

    @Html.EJS().Grid("Grid").DataSource((IEnumerable<object>)ViewBag.datasource).AllowPaging().Columns(col => 

        { 

             ... 

        })...Load("load").Render() 

</div> 

 

<script> 

    var data = @Html.Raw(Json.Encode(ViewBag.datasource)); 

    function load(args) { 

        var grid = document.getElementById('Grid').ej2_instances[0] 

       grid.childGrid = { 

            dataSource: data, 

            queryString: 'EmployeeID', 

            created:created, 

            ... 

       } 

    } 

    function created(args) { 

        this.dataSource = this.parentDetails.parentRowData.Employee;          //Bind the data to Child Grid 

    } 

</script> 

 

 

Documentations :  

https://ej2.syncfusion.com/documentation/grid/api-grid.html?lang=typescript#created 

https://ej2.syncfusion.com/documentation/grid/api-grid.html?lang=typescript#load 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S.