EJ2.Grids set up stacked header column as foreign key column

[Jason Leach]

When making a foreign key column in a grid i do this:

<e-grid-column field="JobDescription" headerText="Job Description" foreignKeyField="ListMemberId" foreignKeyValue="Description" dataSource="ViewBag.jobDescriptions" width="250"></e-grid-column>

and it works great.

when making a stacked header grid column i am using this method

@{

 var stackedHeader4 = new List<Syncfusion.EJ2.Grids.GridColumn>() {

            new Syncfusion.EJ2.Grids.GridColumn { Field = "LeadFound", HeaderText = "Lead Found", EditType="BooleanEdit", Width="140"},

...

}

and it works great.

but I can't seem to get a foreign key in my stacked header column using ViewBag as a source, as I don't seem to have the right syntax.

            new Syncfusion.EJ2.Grids.GridColumn { Field = "RestoreType", HeaderText = "Restore Type", ForeignKeyField="ListMemberId", ForeignKeyValue="Description", [email protected], Width="200"},

and it fails miserably.

anyone know how to do this?

[Jason Leach]

Solved it myself! (yay)

the solution is to use a ViewData["thing"] not VIewBag.

new Syncfusion.EJ2.Grids.GridColumn { Field = "RestoreType", HeaderText = "Restore Type", ForeignKeyField="ListMemberId", ForeignKeyValue="Description", DataSource=ViewData["restoreType"], Width="200"}

[Suganya Gopinath]

Hi Jason,

Thanks for sharing the solution that you have tried. This will be helpful. 

Please get back to us for further assistance. We are marking this thread as solved. 

Regards,

Suganya Gopinath.