Using stored procedures

This example show how stored procedures can be used to select and update data. The following events are available for this:

Note that this sample also demonstrates how to manually create a master-detail relation between table editors. The RowSelected and RowUnselected events from the Master table editors are handled to update the parameters in the related Detail editors.

Customers

Search:  

  CustomerIDCompanyNameContactNameAddressCityCountryPhoneFax
EditOrdersALFKIAlfreds FutterkisteMaria AndersObere Str. 57BerlinGermany030-0074321030-0076545
EditOrdersANATRAna Trujillo Emparedados y heladosAna TrujilloAvda. de la Constitución 2222México D.F.Mexico(5) 555-4729(5) 555-3745
EditOrdersANTONAntonio Moreno TaqueríaAntonio MorenoMataderos 2312México D.F.Mexico(5) 555-3932 
EditOrdersAROUTAround the HornThomas Hardy120 Hanover Sq.LondonUK(171) 555-7788(171) 555-6750
EditOrdersBERGSBerglunds snabbköpChristina BerglundBerguvsvägen 8LuleåSweden0921-12 34 650921-12 34 67
Page: 1 2 3 4 5 6 7 8 9 10 ... Next

   

ALFKI's Orders

  OrderIDOrderDateRequiredDateShippedDate
EditOrder Details1064325-Aug-199722-Sep-199702-Sep-1997
EditOrder Details1069203-Oct-199731-Oct-199713-Oct-1997
EditOrder Details1070213-Oct-199724-Nov-199721-Oct-1997
EditOrder Details1083515-Jan-199812-Feb-199821-Jan-1998
EditOrder Details1095216-Mar-199827-Apr-199824-Mar-1998
Page: 1 2 Next

   

Order Details

 OrderIDProductIDUnitPriceQuantityDiscount
Edit10643Rössle Sauerkraut (Produce)45.6150.25
Edit10643Chartreuse verte (Beverages)18210.25
Edit10643Spegesild (Seafood)1220.25
Page: 1