We're updating some of our product names. K2 Five will soon be Automation On-Prem. You may see both product names in our help pages while we make this change.

TableAdapter Configuration Wizard - Enter a SQL Statement

The TableAdapter Configuration Wizard - Enter a SQL Statement screen gives the developer the ability to write a SQL statement that will populate the data table with the correct data. The SQL statement can either be written in the window provided or the Query Builder can be used to assist the developer in writing the SQL statement.

Fig. 1. Table Adapter Configuration Wizard - Enter a SQL Statement

Feature	What it is
What Data should be loaded into the table?	Type the required SQL statement in the window provided that will fill the data Table with data.
Advanced Options...	Allows the developer access to further configure the query
Query Builder	Is a tool that assists the developer in creating SQL statements

K2 ADO.NET table concepts consist of the combination of both the SmartObject name and the SmartObject Method name. If a query refers to the specific method that must be used as opposed to the default method then the “table” must be quoted. It is recommended that the square brackets are always used for quoting the identifier.