Table

The Table control is used to query a specified table in the data for your project. The TableName, Connection and DataSet settings are configured in the control properties.

Tables are database objects that contain the data in a database, logically organised in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record. In the Flow Designer, you can add a table to display data in a container on a form.

Properties

The key properties for the Table control include:

  • Active. Must be set to True to activate the table and read from the dataset.

  • TableName. Specifies the table in the dataset for the Table control.

  • Connection. Specifies the associated connection for the Table.

  • DataSet. Specifies the DataSet for the table in the Table control.

Adding a Table

When you drag a Table control from the Toolbox to a form in the Flow Designer, it will appear as an entry in the design space. You can select the control and configure it using the Properties pane.

Importantly, you can select the TableName from the configured Connection and DataSet in the Data section of the Properties pane.

The available tables from the data set are listed in the Select Table dialog in a tree format. You can collapse and expand the prefix labels for the tables - for example dbo, GB etc.

If you enter search text in the field provided, the tables displayed in the Select Table dialog will be filtered, with your search term highlighted.

The Find button will perform the search again.

For more information on working with a Table and a DataSet, including how to display the data with a DataGrid control, see Working with Data.

More information on the Table component can be viewed at the link to Microsoft® Documentation.