TableAdapter Configuration Wizard - Bind Commands to Existing Stored Procedures
The TableAdapter Configuration Wizard - Bind Commands to Existing Stored Procedures screen allows the selection of existing stored procedures. In K2 the stored procedures are the SmartObject Methods defined when the SmartObject is built in K2 for Visual Studio.
Fig. 1. Table Adapter Configuration Wizard - Bind Commands to Existing Stored Procedures
| Feature | What it is |
|---|---|
| Select | Select the SmartObject Method that will return the data for a Select SQL Statement. This would be either the SmartObject's GetList or Load Method. |
| Insert | Select the SmartObject Method that will return the data for a Insert SQL Statement. This would be the SmartObject's Create Method. |
| Update | Select the SmartObject Method that will return the data for a Update SQL Statement. This would be the SmartObject's Save Method. |
| Delete | Select the SmartObject Method that will return the data for a Delete SQL Statement. This would be the SmartObject's Delete Method. |
The SmartObject name precedes the SmartObject Method in the drop-down lists. For example, Customer.Load