Render sublists

[Rowan]

If I have a list of MarkCollection objects to display in a grid like below:

public class MarkCollection

    {

        public string StudentName { get; set; }

        public IEnumerable Marks { get; set; }

    }

how can I access an object in the sublist?

e.g.:

@Html.EJS().Grid("Marks").DataSource(d =>

    {        d.Url($"/api/attendance/marks/loadRegister/dataGrid/{Model.WeekId}/{Model.Session.Id}").BatchUrl("/api/attendance/marks/saveRegister").CrossDomain(false).Adaptor("UrlAdaptor");

    }).Columns(c =>

    {

        c.Field("StudentName").HeaderText("Student").Template("#marksStudentTemplate").Width("150").Add();

        for (int i = 0; i < Model.Periods.Count(); i++)

        {

            c.Field("Marks[i].Value").Template($"#marksPeriodTemplate").Width("70").TextAlign(TextAlign.Center).Add();

        }

    }).EditSettings(e => { e.AllowEditing(true).Mode(EditMode.Batch);}).EnableHover().Toolbar(new List() {"Update"}).GridLines(GridLine.Both).Render()

[Thiyagu Subramani]

Hi Rowan, 

 

Greetings from Syncfusion support. 

 

Thanks for your patience. 

 

We have analyzed the reported query “Render sub lists” at our end. 

 

Using the below code example, we accomplished your requirement at our end. Please refer the below code example. 

 

[index.cshtml] 

 

@using gridmvclocalization.Models; 

 

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

{ 

    col.Field("EmployeeID").Width("120").HeaderText("EmployeeID").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Center).Add(); 

 

    Country filter1 = new Country(); 

 

    foreach (var prop in filter1.GetType().GetProperties()) 

    { 

         col.Field("Country."+ prop.Name).Width("120").HeaderText(prop.Name).TextAlign(Syncfusion.EJ2.Grids.TextAlign.Center).Add(); 

    } 

 

}).AllowPaging().Render() 

 

[HomeController.cs] 

 

public ActionResult Index() 

        { 

            ViewBag.LocalData = Complex.GetData(); 

            return View(); 

        } 

 

[Model.cs] 

 

public class Country 

    { 

        public string FirstName { get; set; } 

        public string LastName { get; set; } 

        public string CountryName { get; set; } 

        public int OrderID { get; set; } 

    } 

    public class Complex 

    { 

        public int EmployeeID {get; set; } 

        public Country Country { get; set; } 

        public static List<Complex> GetData() 

        { 

            List<Complex> Data = new List<Complex>(); 

            Data.Add(new Complex() { EmployeeID = 10001, Country = new Country() { CountryName = "Australia", FirstName = "ANATR", LastName = "HANAR", OrderID = 10248 } }); 

            Data.Add(new Complex() { EmployeeID = 10002, Country = new Country() { CountryName = "Bermuda", FirstName = "VINET", LastName = "CHOPS", OrderID = 10249 } }); 

            . 

            . 

            . 

            . 

            . 

}); 

            return Data; 

        } 

 

    } 

 

 

 

Sample link:  https://www.syncfusion.com/downloads/support/forum/146983/ze/gridmvclocalization1586439964.zip 

 

 

 

Please check the sample link and get back to us, if you require any further assistance on this. 

 

 

Regards, 

  

Thiyagu S 

[Rowan]

Hello,

I'm not trying to access multiple properties. "Marks" is a sublist for each of the rows.

I'm trying to access a particular index of "Marks" for each of the columns.

Like this:

c.Field("StudentName").HeaderText("Student").Template("#marksStudentTemplate").Width("150").Add();

                        c.Field("Marks[0].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[1].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[2].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[3].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[4].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[5].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[6].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

                        c.Field("Marks[7].Mark").HeaderText(Model.Session.AttendancePeriod.Name).Width("150").Add();

[Thavasianand Sankaranarayanan]

Hi Rowan,  

  

Thanks for your update. 

In previous update,  we have created a sample for your requirements .In this update we have used complex class EmployeeID and  Country list like your MarkCollection . 

Please refer the code blocks. 

public class Country  

    {  

        public string FirstName { get; set; }  

        public string LastName { get; set; }  

        public string CountryName { get; set; }  

        public int OrderID { get; set; }  

    }  

  public class Complex  

    {  

        public int EmployeeID {get; set; }  

        public Country Country { get; set; }  

  . . . . .  . 

} 

Grid columns rendered below like this.  

foreach (var prop in filter1.GetType().GetProperties())  

    {  

         col.Field("Country."+ prop.Name).Width("120").HeaderText(prop.Name).TextAlign(Syncfusion.EJ2.Grids.TextAlign.Center).Add();  

    }  

You have to achieve your requirement  using the above code blocks. Still your requirement doesn’t met, Please share your  output image and grid rendering code block for further update. 

  

Note: We suspect your requirement may related to hierarchical binding. In this case refer the below help documentation. 

https://ej2.syncfusion.com/documentation/grid/hierarchy-grid/#hierarchical-binding 

Please check the sample link and get back to us, if you require any further assistance on this. 

 

Regards, 

Thavasianand S. 

[Rowan]

With hierarchical binding, can I display child data in the parent table? Instead of expanding to show a sub-table

[Thavasianand Sankaranarayanan]

Hi Rowan, 

 

Query: With hierarchical binding, can I display child data in the parent table  

  

From your query we understand that you need to display both parent and child nodes in the same table with hierarchical binding.  This can be achieved using TreeGrid.  

  

Please refer the below sample,  

https://ej2.syncfusion.com/aspnetmvc/TreeGrid/LocalData#/material  

 

Please ensure whether you want to proceed further with the TreeGrid control  

Regards, 

Thavasianand S.