I have an add and edit page populating a SQL table. The pages use a DropDownDataGrid to allow selection of a foreign key value to be inserted as part of the record. It works perfectly when adding but, when loading the edit page, I don't seem to be able to find a way to set an initial selection within the DropDownDataGrid that works 100% of the time.
If I set the page property which is bound to the Value of the DropDownDataGrid it works perfectly but, only as long at the initial selection is on page 1 of the data in the DropDownDataGrid. If the selection is on, for example, page 5, nothing seems to be getting selected.
Is there a way to accomplish this?