Master Detail

This page contains two table editors. The first displays the Master table (Orders) using the MasterDetailOrders.xml config file. Note that the details button is generated by the presence of a <selectButton> element.

The bottom table editor displays the Order Details corresponding to the selected order. It uses the MasterDetailOrderDetails.xml file. Note that this configuration file contains an ~OrderID~ parameter (corresponding the DetailParameterName in the MasterDetailBinding) that limits the order details to the selected record in the orders table.

Finally, the master/detail relation between two table editors is specified using the MasterTableEditorBinding property of the Order Detail table editor. It specifies the name of the parameter in the details configuration file and name of the primary key column the master table. See the ASPX-page source code on how this property is set up. Note that you can also use the Visual Studio.NET property browser to setup the MasterTableEditorBinding. No programming required!

Orders

Search:  

  OrderIDCustomerIDEmployeeIDShippedDateShipVia
EditDetails10643Alfreds FutterkisteMichael Suyama02Sep97Exotic Liquids
EditDetails10692Alfreds FutterkisteMargaret Peacock13Oct97New Orleans Cajun Delights
EditDetails10702Alfreds FutterkisteMargaret Peacock21Oct97Exotic Liquids
EditDetails10835Alfreds FutterkisteNancy Davolio21Jan98Grandma Kelly's Homestead
EditDetails10952Alfreds FutterkisteNancy Davolio24Mar98Exotic Liquids
EditDetails11011Alfreds FutterkisteJanet Leverling13Apr98Exotic Liquids
EditDetails10308Ana Trujillo Emparedados y heladosRobert King24Sep96Grandma Kelly's Homestead
EditDetails10625Ana Trujillo Emparedados y heladosJanet Leverling14Aug97Exotic Liquids
Page: 1 2 3 4 5 6 7 8 9 10 ... Next

   

Order Details

 OrderIDProductUnitPriceQuantityDiscount
Edit10643Rössle Sauerkraut45.60150.25
Edit10643Chartreuse verte18.00210.25
Edit10643Spegesild12.0020.25
Page: 1