In reality we will be using Infragistic's UltraGrid, but I would like to know if anybody has come up with a pattern/framework to allow a single form with a single DataGrid to bind to a multitude of tables? Which table to bind and display at a time depends on another selection control.
These tables belong to a DataSet and have parent-child relationships. If a child table is bound to the grid, there are certain fields/columns that must display a DropdownList referencing the parent table entries (The UltraGrid makes this task simpler).
Right now I am thinking of authoring controller classes under an inheritance family that takes care of each table in the DataSet. Each class thus has intimate knowledge of the table it is supposed to manage and formats the DataGrid/UltraGrid as necessary to present the data in their best form. They would each have to programmatically generate their own DataGridStyles or UltraGrid DisplayLayouts to match the table schema, I'm afraid.
The melody of logic will always play out the truth. ~ Narumi Ayumu, Spiral