I am using the GridGroupingControl to be able to use the paging functionality (Pager.Wire), which seems to be working just fine. However, I tried adding a related table and the paging disappeared. I tried setting it up a couple of different ways, but it didn't work. If I don't use paging, I get the detail row functionality I expect, but without paging. If I use paging, I don't get the detail row functionality.
GridRelationDescriptor relVendorItemsToItemNeeds = new GridRelationDescriptor()
{
ChildTableName = "ItemNeeds",
RelationKind = RelationKind.RelatedMasterDetails
};
relVendorItemsToItemNeeds.RelationKeys.Add("ITEM_NO", "ITEM_NO");
ItemsGrid.TableDescriptor.Relations.Add(relVendorItemsToItemNeeds);
ItemsGrid.Engine.SourceListSet.Add("VendorItems", dsVendorItemData.Tables["VendorItems"]);
ItemsGrid.Engine.SourceListSet.Add("ItemNeeds", dsVendorItemData.Tables["ItemNeeds"]);
itemsGridPager.PageSize = 15;
//itemsGridPager.Wire(ItemsGrid); //, dsVendorItemData.Tables["VendorItems"]);
// NOTE: Using Pager.Wire does not work with related tables; only Grid.DataSource works.
ItemsGrid.DataSource = dsVendorItemData.Tables["VendorItems"];
itemsGridPager.Wire(ItemsGrid); //, dsVendorItemData.Tables["VendorItems"]);
Any suggestion on how to set this up? Is this possible?
