How to use SQL the SQL Server Service

With the creation of the SQL Tables, Views and Stores Procedures now available as reusable service objects visible in the K2 Object Browser the usability is vast.

For example:

The SQL Server methods can be used in the ADO.NET provider to create forms
In the building of complex K2 processes by using the SmartObject in the wizards to update data tables, store data or retrieve data.
Anywhere where a SmartObject needs to be updated.

Scenario

For a simple step by step example a GridView is created using the List Method created in the SQL Server Service with ADO.NET.

In this example it is necessary to create SmartObjects from the Service Object which in turn allows the method to be exposed

Step 1 - Create a SmartObject

Step 2 - Add a new Method

Step 3 - Create the Web site

Step 4 - Define the Custom Statement or Stored Procedure

Step 5 - Add a GridView and test