Skip to content

SQL Query

SQL Query binding allows you to query data from a database and display it in a table.

Currently, only supports Table control.

  1. Find the 'Table' control in the Tools window of the design page and drag it to the page.

    alt text

  2. Select the table control, in the property bar, click the binding button of the "Table" property, and bind an SQL Query for it.

    alt text

  3. After the binding window pops up, select "SQL Query", then choose the created SQL Query from the Name** dropdown list. Click the **"OK" button to complete the binding.

    alt text

  4. Display the query results in the table control.

    alt text

Note: For more detailed information on using SQL Query, please refer to SQL Query->SQL Query Example->Query ,SQL Query->SQL Query Example->Scalar Query, SQL Query->SQL Query Example->Update Query.