Page History

...

Most database administrators are familiar to with    SQL since it is the most well-known and widely used query language. 

...

Method 1: WhereCondition

The first method you can use is to use the WhereCondition. In this case, the data query will be performed in a table, created at Edit > Datasets > Tables. Since the table is already selected, you only need to supply the conditional. You must also run SelectCommand to update the query.

...

The second method is similar to the first one, but it uses a query, created at Edit>Datasets>Queries and linked to a Provider provider (see image below).

To execute the query, you will have need to select one of the Tables tables from the database , and what whatever condition will needs to be used to filter the data. You need to run SelectCommand to update the query.

...