Hi,
I've GridGroupingControl with multiple Parent/Child relationship and data are retrieved using independent rest service calls. So, on the parent grid, I need to display data from different result-sets and in one of the classic samples, I found a functionality to display data in same grid with primary key/foreign key relationships. I've a data table with two columns (foreignKeyId and foreignKeyText) and I've code something like this:
GridRelationDescriptor descriptor = new GridRelationDescriptor("RelatedTable");
descriptor.ChildTableName = "SourceDataList";
descriptor.RelationKind = RelationKind.ForeignKeyKeyWords;
descriptor.RelationKeys.Add("primaryKeyId", "foreignKeyId");
this.GridGroupingControl1.Engine.TableDescriptor.Relations.Add(descriptor);
this.GridGroupingControl1.Engine.SourceListSet.Add("SourceDataList", dataTable);
So, on the ASPX page, I added a column to parent grid with mappingName = "RelatedTable.foreignKeyText". This works ok and I can see data loaded appropriately.
However, when I search data on GridGroupingControl, the foreignKeyText field doesn't get populated again and it changes to empty text.
Not sure if there are any events that has to be implemented or any properties has to be set on GridGroupingControl, so any help would be really appreciated.
Thanks in advance.